Forum Discussion
Helper IIICircular 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.
Helper II have the same problem but I'm using the CALENDARAUTO(3) function as my fiscal year is from April to March. I do have a lot of reports and tables linked to my calendar table so prefer not to have to redesign all the relationships (more than 500 relationshisps)
Helper IIII 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.