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 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}/reports
This 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.
I can use the REST API to pull a list of apps, workspaces, users, etc. However, the audience one mentioned above does not work and I can't seem to find it in the Microsoft Learn documentation. Is that a feature that is coming in the near future or am I missing something? We are in the process of consolidating workspaces and apps. Would love the ability to get an automatic listing of audiences and user.
- lbendlin1 year agoSuper User
it's been a gap since forever, and there is no indication that Microsoft are even considering to work on it.
Raise a ticket, raise a DCR, speak to your MS rep etc.