← All Power BI refresh errors

Data / model

Circular dependency in a calculated table (SummarizeColumns)

Error code: circular-dependency

Power BI dataset refresh error — what it means and how to fix it.

What this means

SummarizeColumns inside CalculateTable creates a circular dependency (a Sept-2024 behavior change).

How to fix it

  1. Add grouping tables as explicit filter arguments.
  2. Submit all calculated-table edits in one Tabular Editor transaction.
View on Microsoft Learn

Related data / model errors

Catch this automatically

RefreshRadar monitors every Power BI dataset refresh and alerts you the moment one fails — with the likely cause and the fix — so you never hear about a broken refresh from your stakeholders first.

Start free