Forum Discussion
rls for heirarchy data
Hi All,
I have the following fields: Employee Name, Employee ID, Email, Reporting Manager Email, Second-Level Manager Email, Third-Level Manager Email, Fourth-Level Manager Email, and Sales.
The data visibility requirements are:
The 4th-level manager can see data of the 3rd-level manager and all employees sales data under them.
The 3rd-level manager can see data of the 2nd-level manager and all employees sales data under them.
The 2nd-level manager can see data of the Reporting Manager and all employees sales data under them.
- Reporting Manager can see data for all employees under them.
Each employee can see only their own data.
How can this be implemented in Power BI using Row-Level Security (RLS)?
Hi viswaaa ,
please refer below links for more information.
https://community.fabric.microsoft.com/t5/Desktop/RLS-with-org-hierarchy/td-p/1131265
https://www.sqlbi.com/articles/managing-hierarchical-organizations-in-power-bi-security-roles/
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi/
These blogs help in understanding Org RLS and implementing it.The DAX functions PATH,PATHITEM and PATHCONTAINS understanding can help you in building robust RLS.
Please give Kudos or mark its as solution once confirmed.
Thanks and Regards,
Praful
3 Replies
Hi viswaaa ,
please refer below links for more information.
https://community.fabric.microsoft.com/t5/Desktop/RLS-with-org-hierarchy/td-p/1131265
https://www.sqlbi.com/articles/managing-hierarchical-organizations-in-power-bi-security-roles/
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi/
These blogs help in understanding Org RLS and implementing it.The DAX functions PATH,PATHITEM and PATHCONTAINS understanding can help you in building robust RLS.
Please give Kudos or mark its as solution once confirmed.
Thanks and Regards,
Praful
Hi viswaaa,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to Praful_Potphode, for his inputs on this thread.
Has your issue been resolved? If the response provided by the community member Praful_Potphode, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.Hi viswaaa,
Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.
