Forum Discussion

Zaishende's avatar
Zaishende
Frequent Visitor
2 years ago
Solved

RLS Admin bypass

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?

Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    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.

5 Replies

    • Zaishende's avatar
      Zaishende
      Frequent Visitor
      2 years ago

      Hi Ibendlin, 

       

      Thanks for the reply!

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

       

      Thanks.

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        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.