Press "Enter" to skip to content

Avoiding Cyclic References in Power Query

Chris Webb is spinning in circles:

When working in the Power Query Editor in Power BI or Excel, especially when you’re editing M code, you may run into the following error:

Expression.Error: A cyclic reference was encountered during evaluation.

What does this message mean and what causes this error? In this blog post I’ll explain.

Read on for the answers.