topic Re: Use RLS in power bi url in Developer

Use RLS in power bi url

Anonymous — Sat, 25 Sep 2021 23:38:58 GMT

Hi everyone,

I have embedded a power bi report inside salesforce with an url inside an iframe, like the picture below :

But now, I have integrated RLS in my report and I would like to know if it is possible to use the roles created, directly in the url as filter parameters ?

I've searched on the web and they suggested to use embed token but I don't know where and how to use it inside a salesforce page.

Thank you for your help !

Re: Use RLS in power bi url

Greg_Deckler — Sun, 26 Sep 2021 03:39:44 GMT

@Anonymous How did you generate the embed token, is it a Publish to web embed token or something else? RLS cannot be achieved using URL parameters.

Re: Use RLS in power bi url

Anonymous — Sun, 26 Sep 2021 19:26:36 GMT

Hi @Greg_Deckler,

In fact I didn't generate the embed token yet.

I started looking at this link : https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-row-level-security

But I don't know where to inject this code in the visualforce page :

Any idea ?

Or maybe another way to use the rls in an embedded power bi report ?

Thank you very much

Re: Use RLS in power bi url

Anonymous — Thu, 30 Sep 2021 05:29:06 GMT

HI @Anonymous,

AFAIK, current power bi not able to integrate RLS with URL. I'd like to suggest use URL filters instead.

Filter a report using query string parameters in the URL - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

Re: Use RLS in power bi url

Anonymous — Thu, 30 Sep 2021 07:33:00 GMT

Hello @Anonymous, @Greg_Deckler

I figured out how to use RLS in an embedded scenario. In fact, since I used secure embed the RLS is automatically supported as it is written in this article : https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-embed-secure

I have just to be sure that the persons who have access to this report have only read permissions.

It is working really well for me !

Thanks