Search code examples
excelpowerbipowerquerypowerbi-desktopm

A cyclic reference was encountered during evaluation in Power BI

When I press refresh button in Power BI (version 2.112.1161.0) I have this error message

! Table1
A cyclic reference was encountered during evaluation.
! Table2
Loading blocked by failures with other queries.

I always solve it by going to another tab (sheet) and press refresh button and everything's fine. The refresh completes.

Is this error serious? How could I fix it or debug it?

Solution

  • This is a long-standing bug that you can safely ignore. There must be some race condition bug that occasionally causes the PQ engine to fail but as you say, it goes away on its own.

    For others reading, this is different to the circular references errors you sometimes get in the vertipaq engine caused by model ambiguity caused by relationships, multiple calculated columns or genuine logical errors and is to do with the PQ engine.