Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Export user reports shares with powershell

As PBI Admin, is there a way to find all report shares in our PBI service account?

 

I am able to use powershell to export Workspace security using Invoke-PowerBIRestMethod and Group Users endpoint, https://docs.microsoft.com/en-us/rest/api/power-bi/groups/getgroupusers#code-try-0. But this is workspace security not shares. If I export PBI Activity Logs then I can see there is 'Activity' for ShareReport and ShareDashboard, who shared it with 'UserId', and 'ItemName' has the report/dasbhoard name, https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing. The Activity Log has a couple downsides: 1) it says doesn't say who it was shared with, and 2) you can export 1 day at a time. 

 

Please advise how I can find all report shares and the user who was given access. 

 

 

3 Replies