Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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.
Solved! Go to 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.
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.
Thanks!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
8 | |
7 | |
6 |