Use RLS in power bi url

[Anonymous]

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 !

[Anonymous]

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

[Greg_Deckler]

@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.

[Anonymous · Accepted solution]

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

[Anonymous]

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