A Real Live One: Avoid Disrupting Report Subscriptions with the Power BI Admin API
Stakeholders often say, "We need to clean up these reports." This usually means retiring some from production.
Analysts would like to identify a small set of reports users and their subscribers. They want to start the change management process now prior to making any changes to production reports, and they surely don’t wish to disrupt the business process.
Finding individual report users is easy through the service UI…but that’s not what we’re after. Getting report subscribers isn’t a service feature, either. Suggestions for obtaining that data are less than ideal.
“Create a manual Excel log to track Power BI report users and subscriptions? Hold my beer.” Power BI Admin API
As an alternative, we can use the Power BI Admin API to get a report’s subscriber details. The GetReportSubscribersAsAdmin endpoint gives you names, emails and Ids, so you can focus on managing with engaged users, not manual tracking.
The endpoint output solves this. It’s easy to get working, and only a single parameter is required, reportId. OAuth required.
The schema for the JSON output:
The JSON returned has a whole lot of goodies, but we’ll just take what we need:
This has enough information to start a basic list, even conduct those back-channel conversations. This approach keeps everyone informed without a hassle, and you get to know “who is reading what” so you don’t kill the lights by accident.
One less Excel log to worry about.
Power Platform Advisor, Team Lead at Forward Forever
4 个月Great API! Only if I could run it even on a workspace level. Or maybe subscriptions could be part of the scanner API output one day ??