Data / model
Circular dependency in a calculated table (SummarizeColumns)
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
- Add grouping tables as explicit filter arguments.
- Submit all calculated-table edits in one Tabular Editor transaction.
Frequently asked questions
- What does the "Circular dependency in a calculated table (SummarizeColumns)" error mean?
- SummarizeColumns inside CalculateTable creates a circular dependency (a Sept-2024 behavior change).
- How do I fix it?
- Add grouping tables as explicit filter arguments. Submit all calculated-table edits in one Tabular Editor transaction.
- Where does this Power BI refresh error appear?
- It appears in a Power BI semantic model's refresh history when a scheduled or on-demand refresh fails.
Related data / model errors
Catch this automatically
RefreshRadar monitors every Power BI dataset refresh and emails you when one fails, with the likely cause and the fix, so you are not hearing about a broken refresh from your stakeholders first.