Forum Discussion
Dynamic Permissions with Active Directory User Hierarchy Management
I am working on a Power BI Dashboard with row level security (RLS) and dynamic permissions. I need to allow access only to users listed in the data and their supervisors, managers, directors, etc. How do I establish hierarchies for users and their management? (ex. user-->supervisor-->manager-->director-->vice-president-->president)
Thanks.
Seems to work fine
You are not trying to do that as a measure, right? Needs to be a calculated column.
14 Replies
- lbendlin
Super User
read about PATH and PATHCONTAINS
I have read about the PATH functions but none of them work. I get an error each time (command misspelled...). I have a basic test setup with two numeric columns and one name column. Each time I use this syntax "Path = PATH('Employees'[employeeID],'Employees'[managerID])" or "Path = PATH([employeeID],[managerID])" it errors out.
- lbendlin
Path = PATH('Employees'[employeeID],'Employees'[managerID])is correct. Any errors you see will be caused by data quality issues (managerID values missing in the employeeID column).
