Forum Discussion
Solved
power bi rls implementation
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].
The Apply security filter in both directions need to be selected in 2nd relationship, not 1st.
1 Reply
The Apply security filter in both directions need to be selected in 2nd relationship, not 1st.