Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Circular Dependency

When I tried to remove/delete a table from the model that I had build, I am getting the below error:

 

Failed to save modifications to the server. Error returned: 'A circular dependency was detected: ABCD[a_data], ABCD[b_data], ABCD[a_data].

 

Can anyone help me or guide me on how to reoslve this issue.

 

Regards

KR

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Are you able to remove the ABCD[b_data] column and save the changes?

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Whenever two objects refer to each other, a circular dependency is detected so that Power BI cannot handle the object.

     

    When you delete a table from the model, do the remaining tables form a closed-loop relationship? If this is the case, this error may also be reported because Power BI does not allow closed-loop relationships.

    Or ABCD[a_data] and ABCD[b_data] are calculated columns and refer to each other?

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.