Getting a list of all subscriptions for all reports via PowerBI REST API

Power BI Online Service
1

Hi People…

I need to output all subscriptions info for all reports in our PowerBI tenant by PowerShell.

##This will return all the reports:
Invoke-PowerBIRestMethod -url ‘https://api.powerbi.com/v1.0/myorg/admin/reports’ -Method Get

##This will return all the subscriptions for a report…
##But need to add the reportId from above call##
Invoke-PowerBIRestMethod https://api.powerbi.com/v1.0/myorg/admin/reports/{reportId}/subscriptions

How do I pass in a reportId for all reports found from the output of the first call?

Or can this whole thing be done in Power Query?..

Thanks

2

Bumping this post for visibility

3

Has anyone worked with getting the PowerBI REST APIs working in Power Query?..

4

Hi @marcster_uk! We noticed that your inquiry was left unsolved for quite some time now.

Looks like your inquiry was out of the experts and users’ bounds.

We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!