power bi rls implementation

[balaji230]

i have tried creating a relationship between two tables having many to many relations, since it cant be done in power bi , i have introduced an intermediate table and have created two relationships.After implementing RLS,The resulting rows are not according to a selected user[ please find image 5 for reference].i don't know what i am missing out. please find below the steps i have followed.

[Creating 1st relationship]

[Creating 2nd relationship]

[After creating two relationships]

[Implementing RLS]

[The final result].

[v-chuncz-msft · Accepted solution]

@balaji230,

The Apply security filter in both directions need to be selected in 2nd relationship, not 1st.