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.
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?
Solved! Go to 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
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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.
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.
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Is rls can apply for power Bi Pro only?
@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
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |