Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 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 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.