The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Similar to GetGroupsAsAdmin in Microsoft.PowerBI.Api.V2 or the PowerShell cmdlet Get-PowerBIWorkspace, it there a way to retrieve a list of all the workspace/group apps that have been published, and the details including 'permissions' for each app?
Using the REST API GET https://api.powerbi.com/v1.0/myorg/apps only returns rudimentary information about each app, and only for the ones installed / visible to the current user.
I would like to end up with a list of which users (or Active Directory groups) have access to which Power BI Apps.
Hi @Anonymous,
If you are a Power BI Admin and you have a Premium Capacity, try out the Premium Capacity Metric app. We used that app and downloaded the data to Excel for further analysis. You can see all the reports, workspaces, and users info.
Otherwise, RADACAD has this blog where you tap into the Audit Log via PowerShell (again you need elevated role to run the command). Here's the link
Hope this help!
Regards, Peter
Any news about that?
Not a sausage. Looking at the online docs for the API, you can still only get the rudimentary details for each App;
https://docs.microsoft.com/en-us/rest/api/power-bi/apps/getapp