RLS not working between Many to Many tables?

[itsmebvk]

Hi Folks,

I have been trying to apply RLS on one of the dataset I have. Where I have Two security Dim tables, one warehouse Dim table and Two Fact tables.

RLS is working when I have one to many relationship beween Dim and fact tables ( Fact 2), but RLS is not working on Many to Many fact table (Fact 1).

Example : Based on user role it should filter Fact1 and Fact 2 to the warehouse which they belongs to.

If I want to filter my Fact table 1 based RLS and create measures what kind of changes I have to make? Please suggest.

Thank you.

 

[v-angzheng-msft]

Hi,  @itsmebvk 

Many to many relationships not works on power bi.

Try to add a bridge table to link tables who has the multiple records.(modify 'many to many' relationship to 'many to one')
After that, you can enable RLS on this bridge table.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.