Forum Discussion
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
- AnonymousNot applicable
I linked to the PBI Activity Logs method in my post and I do not see OrgAppPermission. Is PBI Activity Logs different than Tenant Audit Logs? The answer you provided on that question states: "Combine the CreateApp and UpdateApp tenant audit logs and use the OrgAppPermission of the latest CreationTime timestamp for each App ItemName."
- lbendlin
Super User
They are different. I am talking about https://protection.office.com/unifiedauditlog