Report Access for each business unit with restricting data view

[yakamoz007]

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. 

[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

[FarhanAhmed · Accepted 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/