Retrieving reports a user has access to using powershell

[Anonymous]

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.

[GilbertQ · Accepted solution]

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...