Sudden circular depency error

[jmvandsdal]

One say when I fired up my Power Bi report I received an error. I didn't think much of it because HubSpot has been making some changes and I just thought that I had to update my queries.

However, now that I need to do the reporting, I can see that the error message is a bunch of messages that completely destroy my report. At first, I tried taking the errors top down, so I had this error:

I looked through my measures and only one measure had the "warning triangle"

I looked at the measure and thought I had found the error since this was an unfinished measure using the countrows function:

I don't really need this measure so I assumed I should just delete it but then all hell broke loose and I got this circular dependency error:

It seems like there's something wrong with my dates table but it had been working just fine until now and I haven't changed anything.

That being said, my dates table is kind of weird. It has two columns with the calendarauto function in them and I have no idea how that came about:

And the structure looks weird

I really need help since rebuilding the report would be nearly impossible

[Testeri]

I've also had this circular dependency error with Desktop since last week with calendarauto(). Working fine with calendar(). Same kind of problem was with Service last month but that is fixed now by MS. I hope they fix this too soon.

[danextian]

Hi @jmvandsdal 

Many users have reported the same issue with CALENDARAUTO() causing circular dependency. Use CALENDAR() instead and specify the start and end dates.

[Ritaf1983 · Accepted solution]

Hi @jmvandsdal 
It seems that you use a calendarauto () for your dimDate table, there is an issue with the November version with this kind of date table, please refer and vote :
https://community.fabric.microsoft.com/t5/Issues/Problem-with-November-2024-update-for-PowerBI-Repor...

until this issue is resolved you can downgrade version of pbi desktop

https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-d...

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