Data source errorA circular dependency was detected

[SSBkrish]

Hi Experties,

 I am getting below error while refreshing the power BI service 

Data source errorA circular dependency was detected: Date[Date-00e6669b-fbd2-4e4e-9ef5-a723bae5d5c8], 21c7b2ea-9cde-4085-955f-3a6a4a2fd876, Date[Date], Date[Date-00e6669b-fbd2-4e4e-9ef5-a723bae5d5c8].

[Anonymous]

Thanks for DallasBaba's concern about this issue.

Hi, @SSBkrish 

This error is usually caused by two or more columns or tables referencing each other, a circular dependency that prevents Power BI from processing the data.

As DallasBaba  said, Measure evaluates reports based on their context and does not create dependencies in the data model. If you have calculated columns that reference each other, you can use a metric value instead of a calculated column.

If you use CALCULATE in a calculated column, it may also cause a context switch, which can cause a circular dependency. You can use ALLEXCEPT or REMOVEFILTERS to limit the columns on which a calculated column depends.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DallasBaba]

@SSBkrish can you check for the relationship and dependencies between your tables. 

Kindly look for any calculated columns that might be referencing each other. You can convert the calculated columns to a measure because measures are evaluate to the context of a report and do not create dependencies in the data model.

You can refer to Marco Russo & Alberto Ferrari blog post on understanding circular dependencies and avoiding circular dependency errors 

Accept as a solution if my post helped you solve your issue.

This will help others find it more readily.