Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Circular dependency error

Hello Everyone   I have a Circular dependency error with tables I have deleted in my document  Can anyone help me how to fix this please!   Kind Regards
Need Help
Show and Tell
Tutorial Requests
Pragati11's avatar
Pragati11
Super User
5 years ago

HI Anonymous ,

 

The error is in some other language so i can't understand it.

Few questions from my side:

  1. Circular dependency error is coming up after you removed tables. Is that right?
  2. Were there any columns used on the report from the tables which you have deleted?

It will be nice to have a detail on the error if possible translated in English 🙂

 

Thanks,

Pragati

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello Pragati11 , yes! this errors are coming from tables already deleted from the model, and there are no columns used in the report from those tables.

     

    This is the translated image 

     

     

     

    • Pragati11's avatar
      Pragati11
      Super User
      5 years ago

      Hi Anonymous ,

       

      Your error clearly states that columns are not found or can't be used in this expression. This means somewhere the columns are refrerred from the deleted tables. May be in visual level filters, or in the reports.

       

      Read the error clearly - "CREATION DATE" not found.

                                         - "CRM Potential" not found.

       

      These errors are more report dependent that these are used some where.

       

      Thanks,

      Pragati

    • Anand24's avatar
      Anand24
      Super User
      5 years ago

      Hi Anonymous ,

       

      There certainly seems to be columns still present which are associated to the deleted table. Creation Date and Cost columns are the 2 that I can manage to understand from the transalated error.

       

      It would be better if you can re-check the columns and make sure any column of the deleted table is not used anywhere.

       

      You can also download an external tool namely "Power BI Helper" that will ease this validation process for you. It will directly give you the columns from each table being used and you should be able to find them.

       

      Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!