Forum Discussion

Mlemmers's avatar
Mlemmers
Helper I
3 years ago
Solved

Help organizational hierarchy RLS

Hi,   I need some help setting up a hierarchy in RLS in PBI. In this scenario (see data below) we have Selma owning department 1 and 2. If I give her access to department 1 and 2 then she can't s...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    yes, we have a rules table that is controlled by the business. It is mostly based on ActiveDirectory but allows for overrides. That table is then matched against USERPRINCIPALNAME in the RLS rule.

lbendlin's avatar
lbendlin
Super User
3 years ago

Treat your access permissions as lists

 

Selma = {1,2}

 

Then in your RLS rules you can test against these lists

 

Department Level 1 in {1,2} => Selma is permitted

Mlemmers's avatar
Mlemmers
Helper I
3 years ago

This is on me for not mentioning it before, but an approach like that wouldn't work if I have 60 of those cases, which I have.