topic Re: Embed Power BI in Sharepoint in Developer

Embed Power BI in Sharepoint

MSchultz93 — Wed, 12 Feb 2025 09:20:54 GMT

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!

Re: Embed Power BI in Sharepoint

Anonymous — Thu, 13 Feb 2025 02:11:51 GMT

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

Re: Embed Power BI in Sharepoint

Poojara_D12 — Thu, 13 Feb 2025 13:04:45 GMT

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.

Re: Embed Power BI in Sharepoint

MSchultz93 — Fri, 14 Feb 2025 09:29:30 GMT

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?