How to get a list of users with whom the PowerBI report is shared

[v-sapotu]

I have a requirement to get the users list with whom the PowerBI report is shared in PowerBI service. I have 50+ workspaces and need to get these details for each report in all workspaces. Is there any automated script for this like PowerShell cmdlets or REST API method?

[negi007]

@v-sapotu  Does below links help you

https://stackoverflow.com/questions/54702764/how-to-extract-all-powerbi-users-and-workspace-access-u...

https://docs.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.workspaces/get-powerbiworksp...

https://morgantechspace.com/2016/06/list-office-365-group-members-using-powershell.html

[Anonymous]

Try actually answering the question

[Anonymous]

@negi007 No. This will help us to get the workspace and the respective users.

But we are looking for something to get the shared with users for a specific report not the workspace users.

thanks.

[negi007]

@Anonymous  I know there is a manual way to get the list of users with whom the report is being shared. Open the dashboard file and under the share tab-> select report -> you can copy and paste the details of the users with whom the report is currently being shared.

I hope till the time you do not find an automated solution, this may help you.

[parry2k]

@v-sapotu surely can be achieved using RestAPI check this blog post.

[v-sapotu]

Thanks for your reply @parry2k . The script in the blog will give the list of users given access to each workspace. My requirement is to get the list of users given access at each report level.

[tracyosimowicz]

I don't think this works anymore. Clicking on Share gives me a different popup.

[Anonymous]

Hi @v-sapotu ,

I also have the same requirement. Any luck on this.

Thanks.