Circular dependency preventing scheduled refresh of data in Power BI service

[Bmann]

Hi, 

Never posted before but have a problem I can't get my head around... This morning I suddenly received failed to refresh notifications for many of our Power BI reports. The reports have been refreshing 3 times per day for several months without any issue until now.  

I have tried re-publishing the reports, sadly this did not help with the issue. The pbix files in the Power BI desktop refresh without any issues. 

The warning given states, "Something went wrong", "A circular dependency was detected..." 

The below post seems similar but does not have a clear solution, it appeared to resolve itself but I can't wait to see if that happens. 

Solved: Circular dependency in Service but not in Power BI... - Microsoft Fabric Community

UPDATE: Issue appears to be related to having a calculated table that uses the CALENDARAUTO DAX function

***UPDATE 18th OCTOBER***

The issue is now on the Microsoft Fabric support page and they're stating that it should be fixed by 20th October... No sign of it on the "known issues" section, but at least it looks like a resolution is due shortly.

link: Microsoft Fabric Support and Status | Microsoft Fabric

[JohnMReynolds]

One of our semantic model data refreshes has suddenly started failing too (in the UK) with a circular dependency error. I don't think we're using any of the CALENDAR functions, though we do have some date manipulation so I may have missed one.

As with the others, refresh via desktop PBI works fine.

[dsj8wksnnckk]

Same here. Reports using CALENDARAUTO() have stopped refreshing due to "Circular dependency"

[AndrejZitnay]

We have this problem on all reports with  aggregate tables. Not just data tables. We use aggegated tables on few other variables.

[MRD87]

I have the same issue. I use Calenderauto in 100+ reports. Applying the workaround would be a lot of work and bad design. I hope this get solved asap.

[AndrejZitnay]

I have same issue in UK across mulitpe reports. It started this weekend. PBIX refresh is ok and online not.

[v-xingshen-msft]

Hi All,
Regarding the semantic model refresh issue in the Power BI service, we have received reports of this issue and the team is actively working on it.
Current mitigation:
The issue can be mitigated by replacing the CalendarAuto function with the Calendar function.
If you are experiencing a similar issue, we recommend trying the above mitigations while we continue to update on the progress of the fix.
Thank you for your patience and support!

[Hogerv25]

Any update for us?

[rren]

Thank you for the update. Since the mitigation is not applicable in my situation (we didn't use CalendarAuto function but Calendar function), could you please provide an ETA for the fix?

[Bmann]

Microsoft have acknowledged the issue and are currently working on a solution. Sadly they've not advised of a timeframe for resolution, though I will post here if I am advised of one

[WhyPBI]

Do you know where they acknowledged this? A link would be good to drive additional comments from the community. Thanks for sharing!

[rren]

Same issue is happening in AU too. It was working fine last firday but failed this morning. Tried a few workarounds mentioned in this post but none of them worked. I'm only using CALENDAR() for the calculated tables. Hope Microsft can fix this ASAP

[power_bi_meh]

The issue still persists in the UK. The solutions from the replies didn't help. We don't use CALENDARAUTO(), and changing the lookback to three years didn't make any difference. I wish Microsoft could look into it ASAP and revert the changes that followed the release of version 2.136.1478.0 on 08/10/2024.

[gwright15]

I've changed mine from CALENDARAUTO( ) to CALENDAR( ) and all seems to be working now

[peterps]

I've had this in the UK too since yesterday for two of our reports, both use CALENDARAUTO to generate a date table and the circular reference is in the date table:

• Data source errorA circular dependency was detected: Date Table[Date Table-f1be7c5e-62ac-4273-b348-abb0c779fae3], 7b92a752-76dd-4b2e-be71-06ab6fc04644, Date Table[Date], Date Table[Date Table-f1be7c5e-62ac-4273-b348-abb0c779fae3].
• Cluster URIWABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net

Desktop refresh works fine so I'm just manually refreshing and pushing up but hopefully it's a temporary glitch and will be resolved soon.

[Bmann]

Yep, all of mine use calculated date tables and Calendar Auto function... I tested replacing the calendarauto with calendar function and it seems to refresh ok. However I'd rather not have to replace across all reports

Power BI support have suggested some code I can run for the workspace in SSMS which I will be testing in due course. 

[peterps]

Thanks!  If it doesn't resolve itself I'll make the change tomorrow

[Newc]

Managed to find a work around. 

• I have a calculated table for dates which has been fine for nearly 5 years...
• This morning I tweaked the code ever so slightly not changing the structure but just the amount of years it was looking back on to 3. it had originally been going back to 1999.
• Did Desktop refresh (which worked as it was anyway)
• Then published and refreshed in service and it worked.
• I had previousley checked relationships and columns and foud no circcular references and hadnt been into the file for months, the only other soluton had been to delete the calculated Dae table which wasnt feasible for this report.

[primolee]

I also have a date table but date column is referenced from another table.  Only thing I did was to remove duplicate and added some more date-related columns.  I did not use calendarauto() or any other calendar functions.  Therefore, I really don't know how to fix it even with your post. (T_T)

Funny thing is, I have other reports and dataset doing the same way but refresh is totally fine.  All these datasets are in the same premium workspace, some datasets are fine, some aren't.

Hopefully Microsoft will come and fix this.

[v-xingshen-msft]

Hi @Bmann ,

In our test environment, the schedule refresh can be used normally, Microsoft Power BI Service status is also kept running, I do not know whether the past almost a day your problem has been resolved, I will keep following up on this issue, look forward to your reply!

[AndrejZitnay]

Can we get any help with this? I can't open microsoft support ticket without fabric subscription

[Bmann]

Good morning, sadly there is no change to the issue this morning - the Datasets continue to encounter the error when trying to refresh