Forum Discussion
Sudden circular depency error
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
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-Reports-circular/idi-p/4284673until this issue is resolved you can downgrade version of pbi desktop
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
3 Replies
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-Reports-circular/idi-p/4284673until this issue is resolved you can downgrade version of pbi desktop
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi jmvandsdal
Many users have reported the same issue with CALENDARAUTO() causing circular dependency. Use CALENDAR() instead and specify the start and end dates.
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.
