topic Re: Embed RLS report to company website in Report Server

Embed RLS report to company website

wasiqkhan — Thu, 30 May 2024 07:45:15 GMT

Hi, I want to publish my RLS (Row-Level Security) report on the company website where my clients can log in using their company IDs. I have implemented RLS security so that only specific clients can access their own data. It's important to note that I don't want to require my clients to create a Microsoft account. I would appreciate it if you could provide the nearest possible solution.

Re: Embed RLS report to company website

d_gosbell — Thu, 30 May 2024 08:57:23 GMT

If you want to use your own custom authentication then you could build a solution using the "Embed for Customers" approach. See Power BI usage scenarios: Embed for your customers - Power BI | Microsoft Learn

Re: Embed RLS report to company website

wasiqkhan — Thu, 30 May 2024 09:13:59 GMT

No, I don't want to develop separate apps for this; I just want to embed a report on the website, provide client login functionality, and enable report filtering according to RLS. thanks d_gosbell

Re: Embed RLS report to company website

d_gosbell — Thu, 30 May 2024 11:53:12 GMT

wasiqkhan wrote:

No, I don't want to develop separate apps for this; I just want to embed a report on the website, provide client login functionality, and enable report filtering according to RLS. thanks d_gosbell

Well you are out of luck since the ONLY way to provide custom login is through an embedded app.

If you use plain website embedding you need to use EntraID for authentication (and the user licensing could be an added complication with this) and if you use publish to web there is no authentication (and therefore RLS does not work)