Get report with RLS using Power BI Rest APIs

[urvilkenia24]

I have a Power BI Premium subscription. I am trying to embed a report in another website in a way such that using the master credentials, I can apply RLS.

For example, let's say I have a Sales Report for which I generate an embed URL or use APIs to access it. I want to embed it in my organisational portal giving master credentials 'admin@myorg.com' and then pass a parameter to the API which gives me the report for a particular role defined in RLS for the report.

Any help is appreciated.

[V-lianl-msft]

Hi @urvilkenia24 ,

Try "map user name" in "manage gateway".

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

[lbendlin]

Are you sure you want to do that?  Normally when you embed Power BI content the security "just works"  because all you do is put the Power BI content in the iframe.  Users will still need to authenticate to Power BI when that content is rendered, which then automatically triggers the RLS.