Embed RLS report to company website

[wasiqkhan]

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.

[d_gosbell · Accepted solution]

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

[wasiqkhan]

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 

[d_gosbell · Accepted solution]

---

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

[d_gosbell · Accepted solution]

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