Forum Discussion
Row level security at different levels
Hi, I have data made up of lots of shops which feed into areas, which in turn feed into larger regions. As a test I've managed to set up three row level securities that map people to shops, areas...
Hi Anonymous ,
Based on my test, you could refer to below links about RLS:
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi
Regards,
Daniel He
The answer to this depends on what your data model looks like and how you map staff to branches.
If your Branch table has columns for BranchManager, AreaManager and RegionManager that contains the Username you could simply create an RLS filter condition like the following:
= Branch[BranchManager] = USERNAME() || Branch[AreaManager] = USERNAME() || Branch[RegionManager] = USERNAME()