r/PowerBI•
Explorer_7548

RLS many-to-many?

Question

I have two tables.

Table1 is a fact table and contains the column Department.

Table2 is a dimension and contains the e-mailadress and Department.

Everyone should be able to see their own department, but multiple people can have the same department.
Can someone explain what I should do for setting up RLS?
I tried to use a bridge table but I still see everything when I view it as a user

Posted Nov 14, 2025, 1:46 PM UTC

1013
Loading comments…