Solved: Row Level Security - Unable to add roles because o...

Anonymous · ‎02-03-2022

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.

Anonymous · ‎02-17-2022

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.

View solution in original post

AllisonKennedy · ‎02-03-2022

@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

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com