Forum Discussion

abhi8569's avatar
abhi8569
Frequent Visitor
3 years ago
Solved

Working with Two Analysis Services Cubes each having RLS

Hello,

I'm currently working on a Power BI report and need to query two Analysis Services cubes. Both of these cubes have Row-Level Security (RLS) defined.

I'm interested in understanding how RLS will function if we import both cubes into a single report. Is there an option to select which RLS should be active?

I appreciate any insights you can provide.

Thank you!

Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    They will both be active, one on top of the other. If their rules contradict each other then the more permissive rule will win.

4 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    They will both be active, one on top of the other. If their rules contradict each other then the more permissive rule will win.

    • abhi8569's avatar
      abhi8569
      Frequent Visitor
      3 years ago

      Thank you for your response! Is this still holds true if we are not using the table on which RLS is defined?

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        3 years ago

        That's a very cheeky question 🙂 , and I don't know the answer. Maybe you can try it out?