Power bi embed and RLS

[KharansuR]

Hi All,

I have a situation where we have embedded our Power bi dashboards on the azure portal through Service principal.

Now we are struggling with the RLS implementation. At the web portal level, our web development team has implemented some user level restriction because of which, the users are not able to see the dashboards at all.

Now we need to facilitate such users with a restricted view of the dashboard by implementing DYNAMIC RLS.

So, it is important to implement Service prioncipal to embed the dashboards to the portal but RLS doesn't work with it.

Does anyone have any solution where the user experience won't be impacted - they click on an web portal object and with sso they directly open the dashboard(without struggling for signing into power bi services again)  and when they open it they have the restricted view as per userprincipal.

Thanks

[Anonymous · Accepted solution]

Hi @KharansuR ,
According to your description, the first thing we need to make clear is that we can't implement RLS through the service body, because when generating embedded tokens, you need to provide username and role. So we can only do it through master user. To implement dynamic RLS, first you need to set up dynamic RLS in your power bi report, and then generate an embed token, but you can also use embedded for organization, in which case you use your organization account to log in, and you can directly identify your current account to generate an embed token. Dynamic RLS.
Using standard cloud based row-level security with embedded content in Power BI embedded analytics -...
Power BI Embedded: Convention-based dynamic Row-level Security (endjin.com)
Enable Row Level Security (RLS) and Embed PowerBI Dashboard in an Application | by Peritos Solutions...
Embed content in your Power BI embedded analytics application for your organization - Power BI | Mic...

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly