How to find how many users have access to PowerBI Reports and Dashboards

[Anonymous]

Hello All,
I have Power BI reports/dashboards distributed on the workspace for many users via Azure AD.
If I need to find the information on the granular level of each user and the reports/dashboard associated with the user, how can I achieve this?

Thanks

[Anonymous]

Thank you for pointing me in the correct direction. However, the requirement is slightly different. Let me rephrase my question: 1. We need to know how many reports/dashboards are present in the Oraganisation Power BI service. 

2. Based on the Reports/Dashboards we need to know which users have access to which report or dashboard. 

Please let me know if you have any further queries. 

Thanks

[_sfrost · Accepted solution]

@Anonymous 

1. You can get the list of Dahsboards/Reports for your entire organization with the help of Admin REST APIs. You can use REST API with Power Shell cmdlets Invoke-PowerBIRestMethod to save the result to any file format.

Reference:

Dashboards: Admin - Dashboards GetDashboardsAsAdmin (Power BI Power BI REST APIs) | Microsoft Docs

Reports: Admin - Reports GetReportsAsAdmin (Power BI Power BI REST APIs) | Microsoft Docs

PowerShell Cmdltes: Power BI Cmdlets reference | Microsoft Docs

2. AFAIK, this is not acheivable. You can upvote the below idea

Microsoft Idea · REST API-To know the Access list of Report/Dashboard when we pass the Report ID or Dashboard ID as an Input to API. (powerbi.com)

Let me know if you have any further questions!

Did I answer your questions? Please accept this as solution!

[_sfrost]

We do not have such a report which provides information regarding the list of reports and who have access to those reports.

You could get a list of reports in your organization tho, with the help of REST APIs, but there seems to be no API to get the list of users who have access to those reports.

To get list of reports in your organization:

Admin - Reports GetReportsInGroupAsAdmin (Power BI Power BI REST APIs) | Microsoft Docs

There is an idea submitted requesting the same. You may upvote it if you would like to see this added in the future.

Microsoft Idea · REST API-To know the Access list of Report/Dashboard when we pass the Report ID or ...

[Anonymous]

Thanks, aj1973, 

But was looking for a report showing insights of all the reports and dashboards in the Power BI service ( on an organization level ) and the users who have access to it. 

[aj1973]

I see!

here is a thread that can help you 

https://community.powerbi.com/t5/Report-Server/How-can-I-get-a-csv-list-of-all-users-who-access-vari...

Or

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing#:~:text=Unified%20audit%20log...

[aj1973]

Hi @Anonymous 

In the power bi service open the report and go to