Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now

Reply
LowriDragon
Frequent Visitor

Existing Power BI report now has circular dependencies in Data Table.

‎11-20-2024 05:07 PM

I have a BI report which I use to track daily sales performance against YTD and MTD targets.

 

The report has been up and working for 2 years now and I update it regularly. However, today the report opens with the below message. It will not refresh and won't do anything now it has circular dependencies. 

 

I have not changed anything in my report, formatting, columns or anything. But today it has just stopped working.

 

Any thoughts? How can I fix my report?

 

LowriDragon_0-1732151149168.png

 

Labels:
Message 1 of 4
430 Views
1 ACCEPTED SOLUTION
danextian
Super User
Super User

‎11-20-2024 09:08 PM

hi @LowriDragon 

This is  known issue if you're using CALENDARAUTO.  It is better to specify the start and end dates using CALENDAR than let DAX do it for you.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

Message 3 of 4
387 Views
0
3 REPLIES 3
danextian
Super User
Super User

‎11-20-2024 09:08 PM

hi @LowriDragon 

This is  known issue if you're using CALENDARAUTO.  It is better to specify the start and end dates using CALENDAR than let DAX do it for you.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Message 3 of 4
388 Views
0
LowriDragon
Frequent Visitor
In response to danextian

‎11-24-2024 02:24 PM

Something so simple but annoying haha

I have no idea why the error started last week. I have changed the report to not use Calendar Auto.

 

Thanks!

Message 4 of 4
349 Views
0
grazitti_sapna
Super User
Super User

‎11-20-2024 09:02 PM

Hi @LowriDragon ,

I hope this information is helpful.

Here's a link to the Power BI Community for further assistance: Link

If I have resolved your question, please consider marking my post as a solution. Thank you!

Message 2 of 4
390 Views
0

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

View All