Row Level Security - Unable to add roles because of cross filter security set to both

[Anonymous]

Hi Experts,

I am facing the below error message while creating roles.

wondering how to solve this. Any idea why would I get that error message?

Appreciate your help.

[AllisonKennedy]

@Anonymous Cross filter direction is in the Model view in your relationships. It should usually be set to Single, so that's one way to solve this. If you can share more details on your relationships in your model we can advise if the both is needed or how to work around it for why it was put in.

Filter slicers without using bidirectional filters in Power BI - SQLBI 

[Anonymous · Accepted solution]

@AllisonKennedy 

Sorry for the delay in my response. I created a bridge table to avoid having both directional filtering and it solved the problem.

Thanks heaps for your helping hand here.