Forum Discussion

alisaleh's avatar
alisaleh
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Circular Dependency Reference around Date[Date] in Service but not Desktop

Hi, Something must have changed in the power bi service recently because I have not made any changes to the report for sometime and all the sudden the refresh schedule is failing with the following ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, alisaleh 

    The issue has been resolved and you can view the changes in the Power BI service.

     

     

    Best Regards

    Jianpeng Li

hly's avatar
hly
Frequent Visitor
1 year ago

Ever since the weekend, every report of mine has failed because of this reason. I've tried every which way to find a work-around. I finally tried your method, and IT WORKED!

 

(Once again - the SOLUTION!)

For ALL calendar table related joins, you MUST change all the 1-on-1 joins to 1-to-many (and make it single, not both ways).

 

alisaleh's avatar
alisaleh
Icon for Advocate I rankAdvocate I
1 year ago

That did not work in my case. It broke something else. The work around are appreciated and might help some poeple but this appears to be a Microsoft Bug. Needs to be treated and  fixed as such. If there is anything we can do to bring this to Microsoft attention sooner please let us know. It seems many people have been affected by this.

  • wwolfg's avatar
    wwolfg
    Frequent Visitor
    1 year ago

    Hi

     

    I made a ticket for Microsot and they did confirm they have an issue that they are working on with clendarauto they still dont have a "public" ETA. 

    I changed from calendarauto to calendar and it worked, I didnt change any relationships, that would have been a disaster in my reports. This is not ideal since we now have 25 reports affected but at least we contained the issue. 

    I hope we have a permanent fix soon.