Forum Discussion
Retrieving reports a user has access to using powershell
Hi Guys,
I am trying to retrieve all the reports a user has access to in a Power BI Tenant.
And, likewise, I want to know for each and every power bi user in my organization.
I am using Windows Powershell to do the same.
The command Get-PowerBIReport -Scope Organizartion gives me ALL the reports in my organization. However, what i wish to know is WHAT ALL REPORTS A SPECIFIC USER HAS ACCESS TO and simillarly for all the power bi users in my organization.
After doing this, I am going to run a query against the audit logs to see if that user is actually viewing the reports he has access to or not. So basically, I am trying to build a usage metric to determine the power bi usage for all the users and organization as a whole.
Can someone please help me with what I am trying to achieve here. I can provide with more specifics if need be.
- Hi there
You can use this new API to get all the details, which will allow to show you which users have access
https://powerbi.microsoft.com/en-us/blog/avoiding-workspace-loops-by-expanding-navigation-properties-in-the-getgroupsasadmin-api/
1 Reply
- GilbertQSuper UserHi there
You can use this new API to get all the details, which will allow to show you which users have access
https://powerbi.microsoft.com/en-us/blog/avoiding-workspace-loops-by-expanding-navigation-properties-in-the-getgroupsasadmin-api/