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.
Hello all.
I am trying to implement DRLS without PATH (I have no manager or manager ID info) to filter report based on hierarchical structure (people see statistics only for themselves and people/departments reporting to them). I have 4 tables (see the screenshot). My concern is how to define the role in Manage roles using information from Organizational structure table and if relationships between tables are ok.
Any advice is much appreciated.
Solved! Go to Solution.
Unfortunatelly did not find any solution so used PATH function to implement it.
Unfortunatelly did not find any solution so used PATH function to implement it.
@Anonymous , refer if one of them can help. MBAS video is helpful.
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
@Anonymous - Not sure if this will help, but see here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Hierarchical-Row-Level-Security/m-p/889567#M406
Unfortunatelly (for me), it uses standard PATH example where manager information is present. I was hoping to get some insights if Hierarchical DRLS is possible without PATH, or somehow avoiding manager details.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |