Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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.

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

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.

View solution in original post

4 REPLIES 4
V-lianl-msft
Community Support
Community Support

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
Super User
Super User

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



Muhammad Hasnain

#LetsConnect https://www.linkedin.com/in/hasnain2587/
mh2587
Super User
Super User

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/



Muhammad Hasnain

#LetsConnect https://www.linkedin.com/in/hasnain2587/
Anonymous
Not applicable

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.