Forum Discussion
Many to Many Relationship - Row Level Security?
Hi Anonymous,
>>Is it possible to have row level security in this situation?
Many to many relationships not works on power bi.
For your scenario, you need to add a bridge table to link tables who has the multiple records.(modify 'many to many' relationship to 'many to one')
After these steps, you can enable RLS on this bridge table.Regards,
Xiaoxin Sheng
what is your grain of security - territory? Or would someone theoretically be secured to employees?
If territory - I would make the security flow one way. If you have both, perhaps setup multiple roles and potentially create an interstitial table using a merge query with all combinations and secure through that?
Not sure if I understand your question completely, but I believe the grain of security would be Employee ID. This employee ID would be tied with their email address so that when they view the report only the territories that are mapped to that emplyee ID would appear.
- Ok, if you have security filter set to be bidirectional or one way from user and you should be fine if relationships exist between the tables. The user id will restrict the user table which will in turn limit the territory table through the inner join type logic.