Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
30 | |
18 | |
13 | |
8 |
User | Count |
---|---|
49 | |
40 | |
32 | |
16 | |
14 |