Forum Discussion
Circular dependency detected error, but I cannot find the problem in my desktop file
Hi Young_G_Han - you may want to consider rebuilding the _Date table without the CALENDARAUTO() function. Instead, use a specific date range with the CALENDAR() function, which can help you manually control the date range and avoid potential conflicts.
eg: _Date = CALENDAR(DATE(2020,1,1), DATE(2024,12,31))
You can use a simpler function like CALENDAR() if you don't need the dynamic nature of CALENDARAUTO().
you can also cross check In Power BI Desktop, you can use the Query Dependencies View to visualize relationships between your queries. This can help you identify where the circular dependency might be occurring.
cross check the model view and connections.
Yes, I am getting a similar error on a scheduled refresh. Error message points to the CalendarAuto table. I recall reading that CalendarAuto could be problematic but had not experienced it directly. The thing is, the model had been stable. I uploaded it some time ago. Since then, the scheduled refresh had completed without errors, until this week. My first thought was "why is this happening now?". Next, "what has changed?" Now I recall that the function actually analyzes the date fields in the model of MIN and MAX values. There must be some new values in my data that are leading to this result.
I found the reason while I solve the problem. I was using the data column and the time column seperately. That caused the circular dependecies in my case.
I used the following measure for the date table.
CALENDAR(DATE(YEAR(TODAY()) - 11,1,1),DATE(YEAR(TODAY()) + 1,12,31))
