Forum Discussion

lovishsood1's avatar
lovishsood1
Resolver I
1 year ago
Solved

Circular dependency Unknown Table

Hi Team,   Suddenly out of nowhere, I received this Circular Dependency error : A circular dependency was detected: DateTable[DateTable], 84c529b2-492a-b469-6a9e-9782359dd997, DateTable[Date], Dat...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • lovishsood1's avatar
    lovishsood1
    1 year ago

    Hey guys, 

    I have resolved this issue by putting relationship of HolidayTable and DateTable to Inactive and used LookupValue function to fetch data from HolidayTable in DateTable.

     

    "IsHoliday", IF(NOT(ISBLANK(LOOKUPVALUE('Holiday Table'[Date], 'Holiday Table'[Date], [Date]))), "True", "False")

     

lovishsood1's avatar
lovishsood1
Resolver I
1 year ago

But I'm not receiving any error in Power BI Desktop only in Power BI service. Why is that?

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi lovishsood1 -Check if you're using incremental refresh in the Power BI Service. If so, try disabling it temporarily to see if the issue persists with a full refresh.Revisit the steps in Power Query that involve the DateTable and ensure there’s no inadvertent circular logic being introduced. check if there is any complex DAX measures, especially time-intelligence or cumulative calculations, as they might be evaluated differently in the service.

 

Simplify the Model: Try isolating different parts of the model or simplifying it temporarily to identify the source of the issue. For example, disconnect certain relationships and see if the problem persists in Power BI Service.