RLS

[HFT]

I have a power bi premium per user license and I want to embed a rls based report in web url, as I can see after integrating the RLS in the report there is no Publish to web URL highlighted (which i am using presently). All the reports which I generate are been embedded in the web page using the Publish to web URL for easy usage.  Now I am working on client based report and should be able to make the RLS embed url be worked in our web page and that to without any extra costing can I achieve it. If yes please let me know the approach.

[HFT]

Any different approach, if it includes license also that is ok, please let me know.

[Akash_Varuna]

Hi @HFT You can't use "Publish to Web" for RLS-enabled reports as it's public .... try these for your requirement

• Use Secure Embed (File > Embed > Secure Embed) for authentication-based embedding on your webpage.
• Ensure all users accessing the report have Power BI Pro or PPU licenses.
• Alternatively, share the report via a Power BI app to enforce RLS.
  If this post helped please do give a kudos and accept this as a solution
  Thanks In Advance

[HFT]

Hi Akash,

I do know about the app, but they do not want to see the report through app and they want to check it in thier product web page. Can you please enlighten me on the first option and can we achieve to publish the url in the client web page and the particular x person should only see their related data and in the same case for y and z.

[Akash_Varuna]

Hi @HFT Use the Power BI REST API to generate embed tokens with RLS roles for each user (X, Y, Z). Authenticate using Azure AD, fetch tokens dynamically, and embed the report on your webpage using the Power BI JavaScript API

[HFT]

Thank you for the response Akash, but I havent used this complex approach before can you please guide me step by step on how to achieve this.

[Akash_Varuna · Accepted solution]

Hi @HFT Could you check these documentationplease 

• Azure AD Authentication: Azure AD Authentication
• Power BI REST API: Power BI REST API Documentation
• Power BI JavaScript API: Power BI JavaScript API Documentation