A circular dependency was detecte:Update failure in power Bi Service,if it works in power Bi Desktop

[Rosebub_]

I have a report that has always worked well and has started to fail since this Monday, on Friday I updated perfectly

 The error it gives is the following:

Error del origen de datos: A circular dependency was detected: CALENDAR[CALENDAR-3a62adfb-f0a9-453d-9a2e-54a730b1e049], 97c30cfb-15ad-4177-8653-370cae7af9b9, CALENDAR[Date], CALENDAR[CALENDAR-3a62adfb-f0a9-453d-9a2e-54a730b1e049].
URI de clúster: WABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net
Identificador de actividad: 0ce150cd-1a22-4801-b9fa-efe337320477
Identificador de la solicitud: 9320b656-a7e3-98c7-d10d-473621123ff6
Hora: 2024-10-17 09:40:37Z

In the Power Bi Desktop version it works correctly, it only fails in Power BI Service

With that description I am not able to see where the error is.

[Anonymous · Accepted solution]

Hi @Rosebub_ 

This issue has been confirmed as a known issue internally. You can try change the CalendarAuto to Calendar function. If this workaround do not solve your problem, please be patient to wait for fixing. If there is any news, I will update it here.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tutu_in_YYC]

This is a known issue, a ticket has been submitted to Microsoft. Many users are experiencing this. 

Refer to this thread
https://community.fabric.microsoft.com/t5/Service/Circular-Dependency-Reference-around-Date-Date-in-...

But also try the solution provided by @rajendraongole1 

[rajendraongole1]

Hi @Rosebub_ - Please review any calculated columns or measures in the CALENDAR table and see if one of them references a field or calculation that indirectly points back to itself. please check the calculated tables and columns, particularly those using CALENDAR, and ensure they don't reference each other in a way that causes loops.

In Model view and review relationships between your tables, particularly those that involve the CALENDAR table. If any relationships are set as bidirectional, try switching them to single direction to avoid looping dependencies.

if above suggestions helps, please start creating a new date table (calendar table) and add your columns/measures step by step and cross check.

Hope the above details helps.