CODEWITHSUNDEEP
powerbipowerbi-desktopmicrosoft-fabric
variable
variable

Reputation: 9714

How to apply RLS to flow via the bridge table?

I have Depo dimension that has 1:M relation with FactSales

I have a bridge table (BridgeOrders) that has a 1:M (birectional) relation with FactSales

And the same BridgeOrders has 1:M (bidirectional) relation with FactCharges

I have static RLS on the Depo table. For example say I have a role Depo1 with criteria Depo=Depo1. Now when testing this Depo1 role using a table visual, I can see that it filters the FactSales and FactCharges Charges used in the visual. As expected, the filter is flowing from depo table to FactSales to BridgeOrders to FactCharges.

However if I create another table visual with Bridge table columns (OrderID) or FactCharges columns then it shows me values across all Depos: say I use OrderIDs (from Bridge table) or Charges (from FactCharges). Why is that?

How to configure RLS in this scenario?

Upvotes: 0

Views: 19

Answers (1)

Sam Nseir
Sam Nseir

Reputation: 12101

Ensure you have Apply security filter in both directions on your FactSales to BridgeOrders relationship selected.

Upvotes: 1

Related Questions