Forum Discussion
Audit Power BI App user list
- 1 year ago
Well, here's the bad news. App audience membership is still not auditable in 2025. All you have is the UI.
- 1 year ago
Hi dmkblesser
Thanks for reaching out to Microsoft Fabric Community Forum regarding Audit Power BI App user list.
To audit and retrieve the list of users for each Power BI App in your organization, including those using the audience feature.
Unfortunately, there is no direct Power BI REST API to fetch the complete list of users for a Power BI App. However, this can be achieved by using the following steps:
1.Use the GetReportsInGroup API to retrieve the list of reports in a specific app workspace.
Ex: GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reportsThis will provide details of all the workspaces, including the ones associated with your Power BI Apps.
2. Retrieve the App Metadata using the Get App API endpoint to retrieve metadata about the app, including its name and configuration.
Ex: GET https://api.powerbi.com/v1.0/myorg/apps
This endpoint will list all apps and their basic metadata, which can be used to filter for Sales and Client apps.
3. For apps without the audience feature(Ex: Sales App), the permissions of the associated workspace reflect the user access to the app. Use the following API to fetch workspace users:
Ex: GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/users (Here, {groupId} is the ID of the workspace).
4.Retrieve Audience-Specific Users, for apps using the audience feature(Ex: Client App), need to fetch the audience information
Ex: GET https://api.powerbi.com/v1.0/myorg/apps/{appId}/audiences
This will return details of all configured audiences, including the distribution lists or individual users assigned to each audience.
For scenarios where APIs are not preferred, it is possible to gather user lists for Power BI Apps by leveraging the Power BI Service and PowerShell. The following steps will be useful:
Using Power BI Service
1.Manually Check Access:
Go to the Power BI Service (https://app.powerbi.com/).
Navigate to the workspace where your app is published then click on the "Settings" gear icon.
Select "Permissions" to see the list of users who have access to the workspace and its contents
2.Check App Audiences:
For apps using the audience feature, go to the app settings.
Check the audience settings to see which distribution lists or users have access.
This approach facilitates the collection of necessary user lists without relying on APIs.
If you have any further questions or need additional help with this, feel free to reach out to us for further assistance!If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.
Hi lbendlin , it's a mixed. I'm using audience feature for some of the apps. and yes my audiences includes distribution lists.
say I have published two apps, one called `sales` App and one called `client` app. for the client app, I'm using the audience feature and for the `sales` App, I'm not using audience feature.
What will be the best way to find out the list of users to those two apps? It's okay to stay at the distribution list level without going into the distribution list and find out each individual within the distribution list, I did write a powershell script to pull the individuals from the distribution list. Thank you!
Well, here's the bad news. App audience membership is still not auditable in 2025. All you have is the UI.
- dmkblesser1 year agoAdvocate II
what about the user list to the app itself without going further down to the audience level?