Forum Discussion
Tracking down circular dependency in a datamart
Hey Devrij ,
The issue with a "circular dependency" could be on two tables or even in a DAX measure/column. I am unaware of any quick-and-easy way to find this. However, the steps I would do is:
1. Determine what changed where...I know you stated that this has been around a long time. But, if it just broke now, what changed? Was it something in a table? A new merge or append perhaps? Or, was it a new measure or column added?
2. If you can't just see what changed where my method has been to open the datamart and then go through the data (dataflows or wherever) and look for the error symbol.
If you find out there is some sort of magical error finder please let us know!
Thanks for the response. Alas, this issue may have been around a long time and we just haven't noticed it until now when we tried to deploy the workspace backwards.
We have 38 tables in this datamart, many with measures and dax columns at some point in the dataflows that lead to it, so while I appreciate there is no magic wand, any advice on whether there was a tool to narrow it down was what I was after.
What Anonymous suggested with the dependency view would have been ideal if it existed in the datamart powerquery menu (if it does, I'm struggling to find it)