Forum Discussion

KatTheDuck's avatar
KatTheDuck
New Member
2 years ago
Solved

Dealing with RLS and many-to-many relationship

Hi, I have been learning power bi for some time and recently I "inherited" a report from a person who no longer works in my company. I was asked to refresh it, so it wasn't difficult, but when I loo...
Need Help
  • marcelsmaglhaes's avatar
    marcelsmaglhaes
    2 years ago

    hey KatTheDuck 


    Maybe you can create a bridge table that contains three columns: EmployeeID, DepartmentID, and a flag indicating if the employee is a manager/deputy (True/False). Then you can create one-to-many relationships from the Employee table to the bridge table and from the Department table to the bridge table, and  you can set the RLS on the department ID in the bridge table where the manager/deputy flag is True.

marcelsmaglhaes's avatar
marcelsmaglhaes
Icon for Super User rankSuper User
2 years ago

hey KatTheDuck 


Maybe you can create a bridge table that contains three columns: EmployeeID, DepartmentID, and a flag indicating if the employee is a manager/deputy (True/False). Then you can create one-to-many relationships from the Employee table to the bridge table and from the Department table to the bridge table, and  you can set the RLS on the department ID in the bridge table where the manager/deputy flag is True.