Forum Discussion
Extracting List of Shared Reports
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
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.
5 Replies
- tayloramy
Super User
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.
v-saisrao-msftCommunity Support
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
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.
