How to create a report on Power BI Access permissions

[kmspsu93]

I am interested in creating a Power BI report (or access somewhere else 0365 Admin portal) where I can get a comprehensive look at Power BI online access permissions across all content.  As our content volume grows, change impact management is not easy when you modify security group membership, as an example.  We should be able to easily find out which Workspaces, Apps, Reports are accessible if I add/remove a user to a user group in O365.  Or the other way...if I modify/delete a Power BI report/app...which security groups will be impacted.

Anyhow...just interested to see if anyone out there has come up with a way to have better visibility into access permission settings.

[aj1973]

Hi @kmspsu93 

You need to use Power BI REST APIs to fetch such infos.

Admin - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[kmspsu93]

Thank you for your reply Amine.  Sorry for the delayed response.  I may be able to get patially there, however I was hoping to get a single pull of all the Power BI objects that have permissions assigned, and a list of the users/groups.  The page you sent me to has opened up some other great opportunities to get info easily (THANK YOU)...but I was hoping to build out a dash that I can easily review permission assignmnets across objects (Workspace, App, Report...etc )

[aj1973 · Accepted solution]

You can build any thing you want in a Power BI report using all the REST APIs necessary. You can use Powershell to call the API then export the data in a json or csv file to store it in your machine or anywhere else. Then connect Power bi desktop to them files to build your report.