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

[caseycook]

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?

[GilbertQ]

Hi there

This script i found might work for you

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

[caseycook]

---

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

[GilbertQ]

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.

[caseycook]

---

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