Forum Discussion
AD group access issue for embedded reports
We have an app embedding PBI reports that are published to an App space in powerBI. Users are granted access using AD group that has been added to the App audience in PBI.
When new users access the embedded report, they see an unauthorized screen. The error persists until the user manually logs into apps.powerbi.com. Refreshing the client UI/embed shows the report as expected.
Removing users from the AD group has a similar effect where the user can view the embedded report despite having been removed from the AD group. Only after logging directly into apps.powerbi.com will the embedded report display the unauthorized screen.
Is this a caching or configuration issue on the PBI side or a synchronization issue with AD?
Any help is appreciated.
Hello devJC
Thank you for your patience and for the detailed analysis you’ve provided. Based on your findings and our investigation, we can confirm that Power BI caches AD group memberships for embedded users, and this cache is only refreshed when users manually log in to the Power BI service.
Since Power BI does not provide an automatic refresh mechanism for AD group permissions in embedded scenarios, we recommend the following approaches:
Manually Remove and Re-Add the AD Group to the App Audience. This is a workaround that can be tested manually first. Removing and re-adding the AD group forces Power BI to re-evaluate group membership. If successful, proceed with automating the process using the Power BI REST API or Power Automation.
If you need any further assistance, feel free to reach out.
Thank you.
11 Replies
hi devJC ,
Thanks for reaching out to the Microsoft fabric community forum.
It seems that the issue is likely due to caching, either on the Power BI side or the user's session (token caching), rather than an AD synchronization problem. I recommend focusing on proper token refresh and investigating the caching mechanisms in Power BI and your embedded app.
Kindly review the troubleshooting steps provided below:
- Implement logic on your app’s embedded client to force reauthentication when users are added or removed from AD groups.
- Investigate how your embedded Power BI tokens are issued and ensure appropriate token expiration policies are in place.
- Make sure there are no significant delays in the synchronization between your AD groups and Power BI.
- Ensure that the browser cache is not interfering with the authorization process.
I am also including a similar thread that has already been accepted as a solution. Please take a look at it for better understanding:
Solved: Users cannot access report but are members of a re... - Microsoft Fabric Community
I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Thanks for the response! I need a couple more clarifications if you can assist.
PowerBI tokens are issued under the powerbi scope using MSAL library in React. The expiration is 30m.
We have tested new users with incognito browser window (no cache, forced clean signin). They still get the unauthorized view until directly accessing powerbi.apps.com. Upon logging into powerbi, the user can access the report.
I am skeptical if the PowerBI security/roles are configured correctly for embedded reports.
Reports and semantic models live in the same workspace and the report is added to the App.
The AD usergroup is added as an audience at the App level and nowhere else.
Does PBI cascade/cache the user's credentials at login?It seems the AD Group in powerBI is cached/stale. How would this be refreshed when new users are added?
We have used the PBI API user RefreshPermissions call with no effect.
Thanks!Hello devJC ,
It seems you're facing issues with user access to embedded Power BI reports, specifically regarding Azure AD group permissions and token management.
Power BI caches user permissions, and when a user logs in, their credentials and permissions are validated against the Azure AD group memberships. If new users are added to an AD group, there may be a delay before those changes take effect in Power BI due to caching. The RefreshUserPermissions API call is meant to update the user's permissions, but if it's not working as expected, it could be due to a few reasons:
- As tokens expire every 30 minutes, ensure users have a fresh token after their permissions are updated.
- If your reports use RLS, confirm that roles are correctly configured, and users have the necessary permissions to view the data.
- Verify that the AD group is properly set as an audience in the app settings and that there are no additional restrictions at the report or dataset level.
I am including a similar thread that might help you. Please have a look into it:
Solved: Powerbi Embed - user owns data - react application... - Microsoft Fabric Community
Additionally, please refer to the following documentation for a better understanding:
Permission tokens needed to embed a Power BI app - Power BI | Microsoft Learn
Troubleshoot Power BI embedded analytics application - Power BI | Microsoft Learn
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
We are embedding using the powerbi-client-react library in React (typescript).
The embedding works as expected except for new/removed users.
