RLS Issue

[Yashpatmase]

Hi, I have implemented rls and almost all the visuals are working fine, but some of the visuals i am getting the error [ I have used userelationship dax and cross filter dax. Please helping for solution on this

[v-priyankata · Accepted solution]

Hi @Yashpatmase 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Akash_Varuna]

Hi @Yashpatmase  I think it occurs because USERELATIONSHIP() and CROSSFILTER() cannot override Row-Level Security (RLS). Ensure your data model relationships and filters align with RLS rules. Avoid using these functions on tables constrained by RLS, and adjust RLS definitions if conflicts arise. If needed, redesign the model or use calculated tables to achieve the desired results without breaking RLS.