RLS Admin bypass

[Zaishende]

Hi Everyone, 

I'm  new here to this forum and excited to work with you guys.

So i've got a problem..

Let's say i've build a repport that's for multiple company's

All the info shown in the repport is based on this main slicer company 450 excists out of three company's: 100, 150 and 200.

For the managers i've put in restriction based on RLS.

Manager 100: 

And so on...

So far so good!

But ofcourse i want grouped information for the ceo and that's where i'm stuck.

I have no data to base the RLS rules on for the grouped data.

Does anyone know a work around? like maybe add an admin like user?

[Zaishende]

That's helped and it's fixed now. 

Thanks buddy!

[mussaenda]

Hi @Zaishende ,

create another rls that doesnt have any filter and add the ceo users.

[lbendlin]

Put in a RLS rule for the CEO that evaluates to TRUE()

[Zaishende]

Hi Ibendlin, 

Thanks for the reply!

I'm not really getting it tho, care to further explain?

Thanks.

[lbendlin · Accepted solution]

Regardless if you use static or dynamic RLS, it all boils down to create DAX formulas that have to evaluate to TRUE() or FALSE() with TRUE() giving access and FALSE() denying access.  Setting the CEO's formula to TRUE() gives them access to everything.