topic Re: How do I make one branch unable to see the other branch data? in Desktop

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

Huga20 — Tue, 11 Aug 2020 08:34:34 GMT

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?

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

amitchandak — Wed, 12 Aug 2020 11:16:03 GMT

@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-in-Power/td-p/712613
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

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

Fowmy — Wed, 12 Aug 2020 11:16:01 GMT

@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 🙂

Youtube Linkedin

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

Huga20 — Tue, 11 Aug 2020 13:37:02 GMT

Is rls can apply for power Bi Pro only?

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

v-alq-msft — Wed, 12 Aug 2020 02:14:14 GMT

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.