How to SharePoint embed with Row Level Security

[avocados12345]

Hi all!

I have a number of reports with row level security set-up in Power BI.

I am able to embed these reports in SharePoint without issue, however when the end user views the report on the SharePoint page, the row-level security does not filter their report.

 -Row level security works for these users when viewed in app.powerbi.com, but we want to display with other elements on SharePoint sites hence the embedding.

-The users accessing the report have Power BI Pro licenses and are listed as members of the workspace where the report/dataset reside.

Is there somewhere I need to indicate the powerbi token for the username and/or role for RLS to be applied in the SharePoint web app?

Thanks in advance!

[Eric_Zhang]

---

@avocados12345 wrote:

Hi all!

I have a number of reports with row level security set-up in Power BI.

I am able to embed these reports in SharePoint without issue, however when the end user views the report on the SharePoint page, the row-level security does not filter their report.

 -Row level security works for these users when viewed in app.powerbi.com, but we want to display with other elements on SharePoint sites hence the embedding.

-The users accessing the report have Power BI Pro licenses and are listed as members of the workspace where the report/dataset reside.

Is there somewhere I need to indicate the powerbi token for the username and/or role for RLS to be applied in the SharePoint web app?

Thanks in advance!

---

@avocados12345

How you embed Power BI into Sharepoint? As per my test, RLS actually works in Embed with report web part in SharePoint Online

[AlexR]

Thanks Eric_Zhang, it works for me too while testing between Pro Users having access to the app workspace.

Do you know if this would also work if we share the report via an App to free users using a premium capacity?

I imagine we just need to add the free users to the Row Level Security groups before publishing the app and embedding the report but could not find anything that confirms this assumption.