Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
You can Implement this in power bi and then embed the dashboard or report in website
Did I answer your question? If so, please mark my post as a solution!
Proud to be a 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/
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |