Unable to execute DAX, A circular dependency was detected, using CALENDARAUTO()，PowerBI WEB works

Hello, I have the same problem for several days, do you know how it has been solved?

Hi NiYH 

There’s already a reported issue regarding CALENDARAUTO() and circular dependencies in the November 2024 Power BI update. Please vote for it here / add some details :
https://community.fabric.microsoft.com/t5/Issues/Problem-with-November-2024-update-for-PowerBI-Reports-circular/idi-p/4284673

However, based on the images you’ve shared, there might also be an underlying design issue in your model that’s causing the circular dependency. This can happen if there are multiple relationships or dependencies between your Dim_Date table and other tables that unintentionally create a loop.

Suggested Steps:
Switch from CALENDARAUTO(): Instead of relying on CALENDARAUTO(), try creating a calendar table manually using either:

DAX:
DAX
Calendar = CALENDAR(DATE(2020,1,1), TODAY())
Power Query: Import a date table or generate one dynamically in the query editor.
This will give you more control and eliminate potential issues caused by automatic column detection in CALENDARAUTO().

Check Relationships: Carefully review all relationships involving your Dim_Date table to ensure there are no unintended circular dependencies.

Report the Issue: If switching to a manual calendar table resolves your issue, this could indicate that CALENDARAUTO() in the latest update is problematic for certain models. Consider commenting or adding details to the linked issue report above.

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

hello good evening, how do you update the PowerBI Server?
THANK YOU IN ADVANCE.

This is embarrassing that Microsoft breaks something in the web service. Fixes it in the webservice, then breaks in in the desktop version. This issue has now been going on for months and no word from Microsoft on a potential solution.