Solved: RLS

HFT · ‎03-11-2025

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.

Akash_Varuna · ‎03-11-2025

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

View solution in original post

HFT · ‎03-11-2025

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

Akash_Varuna · ‎03-11-2025

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 · ‎03-11-2025

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 · ‎03-11-2025

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