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

[LowriDragon]

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?

[danextian · Accepted solution]

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.

[LowriDragon]

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!

[grazitti_sapna]

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!