cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

1 REPLY 1
Highlighted
Super User III
Super User III

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors