Forum Discussion
Solved
Dynamic RLS for organisational hierarchy using path for multiple managers
I have users table where I'm using EmployeeID and ManagerID column to create a hierarchy using path function. This user table is connected to Sales Rep table using EmployeeID. This setup works fine i...
Yes, that's the gist of the discussion here. You can go the hard route, trying to implement that logic with static RLS and multiple roles, or you could go the simple route with dynamic RLS and a precomputed access matrix.
This may help: Managing hierarchical organizations in Power BI security roles - SQLBI
