Forum Discussion
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.
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.
4 Replies
If you are new you may want to use the EASY button.
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.
