PowerBI Rest API

[Bobbertsan]

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.

[lbendlin]

If you are new you may want to use the EASY button.

GitHub - migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector fo...

[Bobbertsan]

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. 

[lbendlin · 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.

[Bobbertsan]

Thanks!