Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

RLS with Muti-level organization Hierarchy

Hi all brilliant people out there, I need a help with RLS set up.

I been working with survey data and created Power Bi report. My reports has 8 Slicers on the Cover page which are actually 8 level of Organization hierarchy. L1 to L8. Now the issue is,  I want to give access to end users for their report and some users will be accessing their report which are in different levels. Plus they also want to see all level below reports. For example if someone has access to one team in level-5 in below table PS then he will be able to see all team reports which are part of that team in all level below L6 SP and DP and in level 7 and level 8. 

Access rule: SOme user will have access to all reports, some user will have access to one report e,g NOF in L3, some will have access PS in L5 some will have SP report in level 7. 

L1L2L3L4L5L6L7L8
ABCTeam1NOFOGPSSPAC
ABCTeam1NOFOGPSSPAD
ABCTeam1NOFOGPSSPBB1
ABCTeam1NOFOGPSDPAA1
ABCTeam1NOFOGPSDPBB1
ABCTeam1NOFOGPSDPCC1
ABCTeam1NOFOGTPSSPAC
ABCTeam1NOFOGTPSSPAD
ABCTeam1NOFOGTPSSPBB1
ABCTeam1NOFODHPSDPAA1
ABCTeam1NOFODHPSDPBB1
ABCTeam1NOFODHPSDPCC1
ABCTeam1ABFOSDPSSPAC
ABCTeam1ABFOSDPSSPAD
ABCTeam1ABFOSDPSSPBB1
ABCTeam1ABFOSDPSDPAA1
ABCTeam1ABFOSDPSDPBB1
ABCTeam2SITSSTPPS   
ABCTeam2SITSSTPPS   
ABCTeam2SITSSTPPS   
ABCTeam2SITSSTPPP   
ABCTeam2SITSSTPPP   
ABCTeam2SSDSSD    
ABCTeam2SSDSSD    

 

Just FYI, my hierachy has multiple teams in some levels plus i also have vs. overall comparsion score in my report which i know works with separate aggregate table but not from same fact table. Thanks