topic Re: How to SharePoint embed with Row Level Security in Developer

How to SharePoint embed with Row Level Security

avocados12345 — Thu, 21 Sep 2017 15:17:28 GMT

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!

Re: How to SharePoint embed with Row Level Security

Eric_Zhang — Fri, 22 Sep 2017 09:42:34 GMT

@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

Re: How to SharePoint embed with Row Level Security

AlexR — Tue, 20 Nov 2018 01:08:21 GMT

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.