Forum Discussion
Query all Users with Access to Reports in Workspace
To create a report that shows the access rights of users to reports in a workspace, you can use the Power BI API and the Microsoft Graph API to retrieve the relevant information.
Use the Power BI API to get a list of reports in the workspace. You can use the GetReportsAsAdmin method to get a list of reports in the workspace.
For each report, use the Power BI API to get a list of users and groups that have access to the report. You can use the GetReportUserAccessList method to get this information.
Use the Microsoft Graph API to get a list of users in your organization, along with their role, team, etc. You can use the Get users method in the Microsoft Graph API to get this information.
Combine the information from steps 2 and 3 to create a report that shows which users and groups have access to which reports, along with their role, team, etc.
You can also automate the process of creating this report on a monthly basis by using the Power BI API and the Microsoft Graph API to refresh the data and update the report.
By creating this report, you can easily monitor and audit the access rights of users to reports in your workspace, and identify users who have changed roles or no longer need access to certain reports.
Thanks for the overview. Good to know that what I'm looking to build is entirely doable.
I'm struggling with step 1 though. can't seem to wrap my head around HTML GET in power query, and getting it to authenticate :S
would you have a example of a query setup to pull in this data?
i'm sure i'll be able to retrofit with my approrpriate ID/URL's from there. did a little googling, and doesn't appear anyone has posted a complete query doing this :S
jaweher899 wetscott
Can you provide any code examples how to get this reporting done.Also can this be extended to all workspaces in the organisation or would there need to be a different sources for different workspaces?
