Customer can see only the data relevant to their Customer#.

[Anonymous]

Dear Community,

hope you all are doing well.

I have hundreds of customers in the PowerBI Report, also I have a website where I use power bi report so customers can see their invoices and other details, etc. Now I want that when customers log in to the web portal through their id password They can only see the data relevant to their customer id, not other customers' data.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

There is a solution provided by Power BI. One account (the master account) is needed. We also can apply RLS. Please refer to embed-sample-for-customers and developer/embedded-row-level-security. 

This blog can also  help you:https://nineboards.com/power-bi-embedded-with-dynamic-rls/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mh2587]

You can Implement this in power bi and then embed the dashboard or report in website

[mh2587]

Suggesting this link for your scenario hope this will work for you

https://powerbi.microsoft.com/en-my/blog/using-username-in-dax-with-row-level-security/

[Anonymous]

Thanks for the answer, Yes I already know about the RLS but how I can implement this in the website where I use the Power BI report so that customers log in to the website and check the dashboard relevant to their customer no.