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 have the following example data and from this I would like to create dynamic row level security to simplify the process on managing permisson levels on reports and ensure people only see what they need to.
EmployeeName | EmployeeNumber | EmployeeEmailAddress | EmployeeUPN | ManagerEmployeeKey | IsManager | IsTrainingManager | IsCoach | IsDeputy | EmployeeKey |
Mark | 1 | mark@example.com | mark@example.com | 1 | 0 | 0 | 0 | 1 | |
Frank | 2 | frank@example.com | frank@example.com | 1 | 1 | 0 | 0 | 0 | 2 |
Sophie | 3 | sophie@example.com | sophie@example.com | 1 | 1 | 1 | 0 | 0 | 3 |
Ruby | 4 | ruby@example.com | ruby@example.com | 2 | 0 | 0 | 1 | 0 | 4 |
Ben | 5 | ben@example.com | ben@example.com | 2 | 0 | 0 | 0 | 1 | 5 |
John | 6 | john@example.com | john@example.com | 3 | 0 | 0 | 0 | 0 | 6 |
Lisa | 7 | lisa@example.com | lisa@example.com | 3 | 0 | 0 | 0 | 0 | 7 |
Paul | 8 | paul@example.com | paul@example.com | 1 | 1 | 1 | 0 | 0 | 8 |
Rebecca | 9 | rebecca@example.com | rebecca@example.com | 1 | 1 | 0 | 0 | 0 | 9 |
Lucy | 10 | lucy@example.com | lucy@example.com | 8 | 0 | 0 | 0 | 0 | 10 |
John-Paul | 11 | john-paul@example.com | john-paul@example.com | 8 | 0 | 0 | 0 | 0 | 11 |
Simon | 12 | simon@example.com | simon@example.com | 9 | 0 | 0 | 0 | 1 | 12 |
Alan | 13 | alan@example.com | alan@example.com | 9 | 0 | 0 | 0 | 0 | 13 |
Visual the org stucture looks like this;
Example
Essentialy its comes down to;
I've tried a few things but I'm having issues with the logic.
Solved! Go to Solution.
Please refer to this blog to set the RLS with organizational hierarchy:
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!
Please refer to this blog to set the RLS with organizational hierarchy:
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-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 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |