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.
Hi,
I want to set a filter on a power bi report for individual end-users (business units who are sitting in different
countries/locations). Everyone should only see their own business unit and none of the others. Is there a possibility to
restrict the report view and lock or restrict the selection of the filter box, so that nobody can see the data of
the other business units? I cannot control this over the the authorization management. Have someone an idea how I can solve
this problem.
Maybe I have to create the report für every business unit. When I have Germany, USA and China then I would have 3 Reports.
I would like to get around that.
Solved! Go to Solution.
I believe you should be implementing Row Level Security in your PBI report instead of creating multiple reports.
see below article for references
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
https://www.sqlshack.com/introduction-to-row-level-security-in-power-bi/
https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi
https://www.biconnector.com/blog/power-bi-steps-to-setup-rls-row-level-security-static-and-dynamic/
https://sqlkover.com/dynamic-security-in-power-bi/
Proud to be a Super User!
Thank you so much for your support! That helped me a lot. I have not the Power BI Desktop just the Power Bi (Power BI User), where I can create DataSets, reports or dashboards. The installation of the Power BI Desktop is for free, or? So I just have to download this? I am really new in this area, sorry for the asking but I know nobody to talk about that.
Yes, Power BI Desktop is free to download and create interactive reports.
If you want to publish your report then you would require a license.
https://docs.microsoft.com/en-us/power-bi/fundamentals/service-features-license-type
https://powerbi.microsoft.com/en-us/pricing/
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-features
Proud to be a Super User!
I believe you should be implementing Row Level Security in your PBI report instead of creating multiple reports.
see below article for references
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
https://www.sqlshack.com/introduction-to-row-level-security-in-power-bi/
https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi
https://www.biconnector.com/blog/power-bi-steps-to-setup-rls-row-level-security-static-and-dynamic/
https://sqlkover.com/dynamic-security-in-power-bi/
Proud to be a Super User!
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 |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
10 | |
5 | |
3 | |
3 |