Extracting List of Shared Reports

[RichMiles]

Hello,

I'm looking to extract a list of all reports that have been shared by users, both from shared and from personal workspaces.  

Is there an API - or any other method - that can extract this list?

Thanks

R

[RichMiles]

Hello,

Thanks for your reply. I can extract the actions - so I know if a report has been shared by filtering on ShredReport operations.

However, because the logs only go back 30 days, I can't find if a report has been shared before this.

I was hoping there is an API that can give me a list of reports that have been shared and who they have been shared with, but I can't find anyhing that does this

[tayloramy · Accepted solution]

Hi @RichMiles, 

That API does not exist. 

If you are the fabric administrator, you can get all users for a specific report: Admin - Reports GetReportUsersAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn

But not for all reports all at once. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[v-saisrao-msft]

Hi @RichMiles,

Thank you @tayloramy, for your insights.
Power BI currently doesn’t provide any API that returns the current sharing permissions of reports, so the limitation you’re facing is by design. Since admins can’t get a tenant-wide list of “who has access to which report,” the best option is to submit this as an idea to Microsoft.

Submit your idea to Microsoft if it gets enough votes, they may consider it in the future.
Raise your idea here: Power BI Ideas Forum.

Fabric Ideas - Microsoft Fabric Community

Thank you.

[v-saisrao-msft]

Hi @RichMiles,

Have you had a chance to review the solution we shared by @tayloramy ? If the issue persists, feel free to reply so we can help further.

Thank you.

[tayloramy]

Hi @RichMiles, 

I don't think there's an endpoint for just shared reports, but there is an endpoint for getting all activity events: 

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

This data only goes back 30 days. 

I have a process in my environment that pulls data daily for the previous day and stores it in a database so I have a full audit log. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.