Sign in Options for Reports Embedded in Website With Row Level Securtity

Hi Anonymous 

I don't think you will be able to do what you want with "standard" Power BI licencing. Using  "Pro" or "PPU" licences require the user to authenticate on to Power BI so that Row Level Security knows who the user is and what level of access they have. This doesn't work with any "Single Sign On" system that I know of.

However what I think you need to look at is Power BI Enbedded. This address your scenario of embedding Power BI functionality on your own web site, managing user authentication and security.

See Power BI embedded analytics overview - Power BI | Microsoft Docs Specifically the section on "Embed for your Customers"

Hope this helps

Stuart