Forum Discussion

koralka's avatar
koralka
Icon for Helper I rankHelper I
9 months ago
Solved

Circular Dependency Error

Hey all, I’m dealing with a very unusual issue in a mixed-mode (Import and Direct Query) Power BI semantic model (over 5GB, used across many dependent reports) - I am not the author of that model. ...
Need Help
  • koralka's avatar
    koralka
    8 months ago

    Hello, thank you for your reply. Apologies for delayed response, I was on annual leave. 

    I wouldn't be able to provide screenshots of the model as it's company's data but also, this model in large and relationships aren't really clear from just looking at the visual represenation of them. I managed to solve the issue with duplicating some tables and changing the relationships between them. I am still unsure how it's possbile that it was working fine and no wors was done on those tables for months and then it suddenly broke... 


tayloramy's avatar
tayloramy
Icon for Super User rankSuper User
9 months ago

Hi koralka, 

 

THe first thing I would do is make a copy of the model in a dev workspace that has no downstream dependencies, so you can do whatever you need to to get it refreshing again without impacting anything, and then once you know how to fix it, you can implement the changes in the production model. 

 

I would start by deleting and re-creating that table. Those partitions seems sus to me. 

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

koralka's avatar
koralka
Icon for Helper I rankHelper I
9 months ago

Hi tayloramy 
Thank you... Yes, I am making changes in dev. The issue is - I start to think that the error message isn't actually pointing to the actual error. I've 'fixed' (made some changes) so what could have possibly be causing the circular dependency error on those targetRevenue tables and refresh failed with another circular dependency error on completely different tables. Interestingly, both are calculated tables from other tables that pull from SharePoint


  • tayloramy's avatar
    tayloramy
    Icon for Super User rankSuper User
    9 months ago

    Hi koralka, 

     

    Interesting. Could you share more details? Could we see a sdcreenshot of the model view so we can see relationships? 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

    • v-aatheeque's avatar
      v-aatheeque
      Icon for Community Support rankCommunity Support
      9 months ago

      Hi koralka 

      Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

      • v-aatheeque's avatar
        v-aatheeque
        Icon for Community Support rankCommunity Support
        9 months ago

        Hi koralka 

        Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.