Hi @MSchultz93
To dynamically show or hide Power BI apps on a SharePoint page based on user roles (Employees, Partners, Admins), you need to control visibility at the SharePoint level rather than just using Row-Level Security (RLS) in Power BI. The best approach is to use SharePoint Audience Targeting combined with Azure AD security groups. First, create three security groups in Azure Active Directory (AAD): one for Employees, one for Partners, and one for Admins. Then, configure Power BI app permissions to ensure Employees can only access the Employee-app, Partners can access both the Employee-app and Partner-app, and Admins have no access to either. In SharePoint, use the Power BI web part and enable Audience Targeting so that each embedded report is visible only to the correct group. This ensures that Employees see only their app, Partners see both apps, and Admins see none. If additional flexibility is needed, a custom SharePoint Framework (SPFx) solution can be implemented to dynamically retrieve user roles via Microsoft Graph API and control the visibility of embedded reports. This approach ensures that users only see the reports they are meant to access, rather than just restricting the data within the reports.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"
Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
