RLS and Circular Dependencies

Hi Anonymous ,

There many reasons for this condition, but mostly, issue come from calculate table created via DAX.

Best and fast way is change the cardinality to many-to-one from one-to-many between fact table and calculate table. Or add allexcept() function in the end of the code used to create a column.

If it does not work, please consider learn more about circular dependencies from this article below.

https://www.sqlbi.com/articles/understanding-circular-dependencies/ 

Best Regards

Community Support Team _ Chenw Zhu

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