Forum Discussion

abhiram342's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
Solved

Option to Disable/Bypass the RLS on active relationship

Hi Team - We have tabular model (screenshot below) and enabled RLS on the "DimCustomer" table, which is currently security applying the filter to both the "FactSales" and "FactCompute" tables. Howev...
Dynamic RLS
Need Help
RLS
RLS problems
  • OwenAuger's avatar
    OwenAuger
    3 years ago

    Hi Abhiram,

     

    With Option 2, with a clone of DimCustomer, I think it would work fine if you have it set up with:

    1. The clone of DimCustomer used for RLS purposes (let's call it DimCustomerRLS) related to just Fact Sales.
    2. The original DimCustomer related to both Fact Sales and Fact Compute.

    This should allow RLS to fliter Fact Sales via the relationship with DimCustomerRLS, but for visuals you would just use DimCustomer, which would filter both Fact Compute and Fact Sales.

     

    Also, I would recommend hiding DimCustomerRLS.

    (Oh and I'm not sure if DimUser is used outside RLS. If so, it might also need to be cloned.)

     

    Would this work for you?

     

    Regards

     

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
3 years ago

Hi Abhiram,

 

With Option 2, with a clone of DimCustomer, I think it would work fine if you have it set up with:

  1. The clone of DimCustomer used for RLS purposes (let's call it DimCustomerRLS) related to just Fact Sales.
  2. The original DimCustomer related to both Fact Sales and Fact Compute.

This should allow RLS to fliter Fact Sales via the relationship with DimCustomerRLS, but for visuals you would just use DimCustomer, which would filter both Fact Compute and Fact Sales.

 

Also, I would recommend hiding DimCustomerRLS.

(Oh and I'm not sure if DimUser is used outside RLS. If so, it might also need to be cloned.)

 

Would this work for you?

 

Regards