RLS apply security filter issue

[Anonymous]

Spoiler

I have a  one dimmension table and one user table.I want to apply Rls and hence want to filter this dimmension table by firstly user table and for more condition by another table.But while apply birectional filter to dimmension table from other two tables I am able to select apply cross filter from only one table.As soon as i select the apply cross filter from other table it giving following error:The table already has a relationship with security filtering set to both.Only one relationship per table is allowed.What is the solution for this.Note the two tables cannot be joined together

[Anonymous]

Hi  @Anonymous ,

Probably because introducing this join creates such a loop in your data model, resulting in ambiguous table usage.

In this, when you introduce a relation between Table B and Table D, it's morelikely that it would result in a loop. The Case might be your Table C and Table D are already related. Since your Table B and Table C are related, if you introduce a new join between Table B and Table D, that will result in a loop as Table B and Table D are already related by an indirect relationship through Table C

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/Row-level-security-and-relationship/m-p/660109

https://community.powerbi.com/t5/Desktop/Row-level-security-and-bidirectional-cross-filtering/m-p/810722

https://community.powerbi.com/t5/Desktop/RLS-using-an-inactive-relationship/td-p/1017906

https://community.powerbi.com/t5/Desktop/What-does-it-mean-to-apply-a-security-filter-in-both-directions/td-p/2336394

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.