Forum Discussion
Helper IReport Access for each business unit with restricting data view
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. 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/
3 Replies
FarhanAhmedCommunity Champion
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/
- yakamoz007
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.
- FarhanAhmed
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