Circular dependency error

[Anonymous]

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

[Pragati11]

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]

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 

[Anand24]

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 !!!

[Pragati11]

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