How to extract a list of reports and users with access across all workspaces?

[syl-ade]

Hi All,

I'm looking for a way to programmatically extract a list of Power BI reports along with the users who have access to each report across all workspaces in our tenant.

I have full access to all workspaces, but I’m not a Power BI Service Administrator, so I can’t use the admin-only endpoints like admin/reports/{reportId}/users.

So far, I’ve managed to:

• List all reports using Get-PowerBIReport within each workspace.
• List users with access to each workspace using groups/{groupId}/users via REST API.

However, this only gives me workspace-level access, not report-level sharing details (e.g., if a report was shared directly with a user outside the workspace).

Is there any method, API, or workaround that allows me to get:

• A list of reports,
• And for each report, a list of users it has been shared with (including direct sharing)?

Any help or guidance would be greatly appreciated!

[v-dineshya · Accepted solution]

Hi @syl-ade ,

Thank you for reaching out to the Microsoft Community Forum.

Power BI REST API's do not currently support retrieving report-level sharing details unless you are a Power BI Service Administrator. The endpoint admin/reports/{reportId}/users is restricted to admins only. If you can List reports using Get-PowerBIReport and List workspace users using groups/{groupId}/users. These only provide workspace-level access not report-level sharing.

Solution: Manual Sharing Audit via UI, You can manually check sharing details by Opening the report in Power BI Service.

Please refer below Microsoft documents and community threads.

https://learn.microsoft.com/en-us/rest/api/power-bi/reports/get-reports 

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/widely-shared-artifacts-links-shared-to-wh...

https://community.fabric.microsoft.com/t5/Service/Auditing-report-dashboard-access-without-Tenant-Po...

https://community.fabric.microsoft.com/t5/Service/Power-BI-workspace-get-users-permissions-list/m-p/...

https://community.fabric.microsoft.com/t5/Service/Get-a-list-of-all-reports-and-dashboards-in-my-org...

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-a-catalog-of-reports-from...

https://community.fabric.microsoft.com/t5/Desktop/Custom-Usage-Metrics-Report-for-all-reports-and-al...

https://community.fabric.microsoft.com/t5/Desktop/Power-Bi-report-listing-ALL-workspace/td-p/2911858

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[v-dineshya]

Hi @syl-ade ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[v-dineshya]

Hi @syl-ade ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[v-dineshya]

Hi @syl-ade ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh