cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
balaji230 Frequent Visitor
Frequent Visitor

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].1.png2.png3.png4.png5.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: power bi rls implementation

@balaji230,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: power bi rls implementation

@balaji230,

 

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

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