Forum Discussion
RLS and Circular Dependencies
Circular Dependencies -There are many datasets that are linked complexly with each other. Due to so many relationships and complex data models, PBI shows Circular Dependency error while performing row-level security on multiple tables column filters. What’s the best practice to handle this?
2 Replies
- lbendlin
Super User
Reduce the complexity, connect to fewer datasets, selectively pick only the tables you need from each dataset, rethink the need for RLS.
- v-chenwuz-msft
Community Support
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.
