Embed Power BI in Sharepoint

[MSchultz93]

Hi, 

I have a bit more complex usecase embedding Power BI apps on a Sharepoint. The issue is the following,

There exists 3 different types of roles at the company

    - Employees

    - Partners

    - Admin

There exists 2 Power BI apps

     - Employees-app

     - Partner-app 

On the start site on Sharepoint the following is requested. 

     - Employees, only see the Employee-app

     - Partners, only see the Employee-app and the Partner-app

     - Admins, see neither app

How would I show/hide reports based on the role the person has. Simply using RLS doesn't work, since the reports should be complete hidden.

Thank you!

[Poojara_D12]

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.

[MSchultz93]

Hi, 

Thank you for your reply! I have created the groups as you said and I've created the embeded Power BI reports, however I cannot find audience targeting for the spcific Power BI object. Where is that setting?

[Anonymous]

HI @MSchultz93,

AFAIK, current the embed to SharePoint feature seems not support advanced customize based on users.
Perhaps you can try to create different versions of report based on requirements and share to different users.
In addition, you can also submit an idea about improve the embed to SharePoint features.

Microsoft Fabric Ideas

Regards,

Xiaoxin Sheng