How do I make one branch unable to see the other branch data?

[Huga20]

I created a dashboard with a branch name filter (I have 100 branches), then I want to share the dashboard with all these branches. How do I make one branch unable to see other branch data?

[amitchandak · Accepted solution]

@Huga20, it's best to use RLS - Row-Level Security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi

[Fowmy · Accepted solution]

@Huga20

You can make use of RLS - Row Level Security:

See: https://www.youtube.com/watch?v=9wN33rTaiB4
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click the Thumbs-Up icon on the right if you like this answer 🙂

YoutubeLinkedin

[v-alq-msft · Accepted solution]

Hi, @Huga20 

No matter which option you choose, to share your content you need a Power BI Pro license, or the content needs to be in a Premium capacity. License requirements vary for the colleagues who view your content, depending on the option you choose. If you are a free license, the content with rls can be applied when it is in a Premium capacity and the user has only read access to the dataset.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy · Accepted solution]

@Huga20

You can make use of RLS - Row Level Security:

See: https://www.youtube.com/watch?v=9wN33rTaiB4
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click the Thumbs-Up icon on the right if you like this answer 🙂

YoutubeLinkedin

[Huga20]

Is rls can apply for power Bi Pro only?

[amitchandak · Accepted solution]

@Huga20, it's best to use RLS - Row-Level Security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi