Embedding and Report Filters

[BAflow]

Hi

I am looking a embedding Power BI onto our website, I have read several pieces on this some are quote old so I wanted to check on the latest functionality, what I need to know is;

A user logins into my webite through a secure Auth0 login, I then want to offer them the ability to see on dashboard various reports, I want this to work in a way that I create a general report in Power BI for all companies that could login to my platform, I then want to have the functionality to filter the report so it only shows the data for the user logged in?  Basically I have 2000 companies that login to my website, I don’t want to make a report per company in most casesI would like to make generic reports and then have the ability to use the unique company reference in my database to filter the reports so the users only see their companies information.  Can someone pont me in teh right directin for how to do this please? Thank you

[Anonymous]

@BAflow,

You can use Row Level security(RLS) feature to restrict user access to particular data within a report, and to embed report to website, you can use Power BI embedded feature. For more details about combining RLS and Power BI embedded, please review the following article.

https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-rls

Regards,
Lydia