cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Export list of users who have access to App (Get-PowerBIApp) ?

I need to be able to export a list of every App and the users who have access to the app.  This is for a quarterly user access audit.  I was hoping there would be some way of doing this in Powershell, but I haven't found it yet.  I can run Get-PowerBIWorkspace to get workspace user access, but there is no Get-PowerBIApp cmdlet.  I also don't see anything available in the REST API to pull it.  Is this even possible?

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Export list of users who have access to App (Get-PowerBIApp) ?

Hi there

This script i found might work for you

https://github.com/msfttimmac/MyPowerBIPowerShellSamples/blob/master/Get_AllReportsInAllWorkspaces.p...




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

Proud to be a Super User!







Power BI Blog

Highlighted
Helper I
Helper I

Re: Export list of users who have access to App (Get-PowerBIApp) ?

 


@GilbertQ wrote:
Hi there

This script i found might work for you

https://github.com/msfttimmac/MyPowerBIPowerShellSamples/blob/master/Get_AllReportsInAllWorkspaces.p...

Thank you for sending this over.  However, it does not address my request.  I need to be able to see which users are listed in the App permissions tab.  I need to pull this for every app quarterly.  I'm looking for some way to automate the export of the data.  I will need to pull user access audits for every aspect of Power BI so anything you have that can help with that would be appreciated.

Highlighted
Super User IV
Super User IV

Re: Export list of users who have access to App (Get-PowerBIApp) ?

hi there

This is the API call which will work, which I am sure you can modify from the sample above.

https://docs.microsoft.com/en-us/rest/api/power-bi/admin/groups_getgroupsasadmin

One thing to note is that the expanding of the user only applies to V2 of the App Workspaces.




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

Proud to be a Super User!







Power BI Blog

Highlighted
Helper I
Helper I

Re: Export list of users who have access to App (Get-PowerBIApp) ?


@GilbertQ wrote:
hi there

This is the API call which will work, which I am sure you can modify from the sample above.

https://docs.microsoft.com/en-us/rest/api/power-bi/admin/groups_getgroupsasadmin

One thing to note is that the expanding of the user only applies to V2 of the App Workspaces.

 

Thanks for your response, but I don't see how to return the "App" permissions from this. It seems to be the users of the workspace, not the users you share the App with when publishing.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors