Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Many to Many Relationship - Row Level Security?

So I have two tables. A fact table with Territory ID's and then the Employee table has Empolyee ID's and Territory ID's.   The Employee table has a many to many relationship between Employee ID's a...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • Dina's avatar
    Dina
    New Member
    4 years ago

    Hey Anonymous , how can I apply RLS to the bridge table? I have a similar scenario where I have one customer and many issuers (the security table) and then I have a dimension for the issuers. I created a bridge table of distinct issuers and I created a relationship with the dimension and the security table (both way filtering on both tables). When I applied RLS to the user security table it doesn't work.

     

    Could you please elaborate more how do you apply RLS on the bridge table?

    Thanks a lot!