Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Bobbertsan
Regular Visitor

PowerBI Rest API

OK. I am new at PowerBI Rest API as well as M query language. My boss wants me to use PowerBI API web connection to get all report info for all workgroups. But in order to get report info I need the workspace id.

 

So what I need to do is create a table using some sort of nested loop. 

 

Do

    Get groups using the get-groups api call

 

     save the groupid from that call in a parameter parmGroupID

 

     get report information from that group by using the get-reports in group api call which has the parameter i just retrieved from         the previous call:

   "https://api.powerbi.com/v1.0/myorg/groups/"&parmGroupID&"/reports" 

 

Loop - then go back up and get the next group

 

but I am not sure how to do it. I think parsing JSON may be involved, but I don't know how and I can't find any examples online.

 

Please help.

 

Thanks!

 

Sorry if my pseudocode above is confusing.

1 ACCEPTED SOLUTION

It's not just the "hard"  way. It's also the "impossible in the service"  way.  Tell your boss to stop torturing you.

 

To make it clear:  You MUST use a custom connector. Either the ready made one, or your own.

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

I already know about that one, thanks. My boss wants me to do it both ways - using the custom connector AND the hard way. Just in case management won't let us use the custom connector.

 

I appreciate the qucik response. 

It's not just the "hard"  way. It's also the "impossible in the service"  way.  Tell your boss to stop torturing you.

 

To make it clear:  You MUST use a custom connector. Either the ready made one, or your own.

Thanks!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.