DAX Text Functions Cheat Sheet
A fast, scannable reference for the DAX text functions you'll actually reach for — substrings, case and whitespace, combining values, replacing text, and formatting numbers as strings.
DAX Error: A Function 'CALCULATE' Has Been Used in a True/False Expression
This error means CALCULATE() got nested directly inside a boolean condition instead of being used the way it's meant to — as the outer wrapper. Here's the actual rule, and the two ways people usually trip it.
DAX Error: A Table of Multiple Values Was Supplied Where a Single Value Was Expected
This error means a table-returning expression — VALUES(), FILTER(), RELATEDTABLE() — ended up somewhere DAX needed a scalar, and had more than one row to give it. Here's why it depends on filter context, and how to fix it.
Power Query Error: We Cannot Convert the Value Null to Type Table
This error means a step expected a table but received null instead — usually from a filter that matched nothing, a failed merge, or a source that returned nothing this time. Here's how to find which, and the fix for each.
Power Query Error: There Were Too Many Elements in the Enumeration to Complete the Operation
This cryptic error almost always comes from Table.Pivot hitting duplicate row/column combinations with no aggregation function to combine them. Here's what it actually means, and the fix.
DAX Error: Comparison Operations Do Not Support Comparing Values of Type Text With Values of Type Boolean
This DAX error means a comparison mixed two different data types on either side of an operator. The most common trigger is an Excel-style habit that doesn't translate to DAX. Here's why, and the fix.
Power BI Error: There Isn't Enough Memory to Complete This Operation
This memory error almost always means too much raw, unaggregated data is being pulled into Power BI Desktop at once. Here's how to find what's actually consuming the memory, and the fixes for each cause.
Power BI Error: OLE DB or ODBC Error
"OLE DB or ODBC error" is a wrapper around several unrelated causes — a login failure, a missing driver, a timeout, or a gateway credential mismatch. Here's how to tell which from the details, and the fix for each.
Row-Level Security Works in Desktop But Not in the Power BI Service
RLS filters correctly when testing with "View as Roles" in Desktop, then shows everyone all the data once published. Here's why that happens, and the four usual causes.
Power Query Error: Web.Contents Can Only Accept a Literal String as the First Parameter
This Formula.Firewall error means Web.Contents' URL was built dynamically instead of being a literal string. Here's why the Power BI Service enforces this when Desktop doesn't, and how to fix it with RelativePath.
DAX User-Defined Functions Are Here — What You Need to Know
DAX user-defined functions reached general availability with the June 2026 release. Here's what changed, the FUNCTION syntax in plain terms, and when they're actually worth using over a measure.
Why Did My Power Query Refresh Suddenly Get Slower?
A refresh that used to take seconds and now takes minutes, with no error and no obvious cause, almost always means query folding silently broke somewhere. Here's how to find exactly which step, and the four usual causes.
Power Query Error: We Couldn't Convert to Number (or Date)
"DataFormat.Error: We couldn't convert to Number" (or Date) usually isn't bad data — it's a locale mismatch, hidden whitespace, or a stray non-numeric value. Here's how to find which, and the fix for each.
Power Query Error: Formula.Firewall and Privacy Level Errors
"Formula.Firewall: Query references other queries or steps, so it may not directly access a data source" comes from Power Query's privacy level checks, not a bug in the query. Here's what triggers it and how to fix it properly.
DAX CALCULATE Modifiers Cheat Sheet
A fast, scannable reference for the filter-modifying functions used inside CALCULATE — ALL, ALLEXCEPT, ALLSELECTED, REMOVEFILTERS, KEEPFILTERS, and USERELATIONSHIP.
Power BI Error: Couldn't Load the Data for This Visual
"Couldn't load the data for this visual" is a generic banner covering several unrelated causes. Here's how to read the real error underneath it, and the four usual culprits.
Power BI Error: A Single Value for Column Cannot Be Determined
This error means a measure referenced a column directly instead of aggregating it. Here's why it often works at the row level and breaks at the total, and how to fix it.
Power BI Error: The Key Didn't Match Any Rows in the Table
"The key didn't match any rows in the table" comes from LOOKUPVALUE finding zero matches, not too many. Here's how to find why, and the four usual causes.
Power BI Error: Column Contains a Duplicate Value
"The column 'X' in table 'Y' contains a duplicate value" happens when you try to build a relationship on a column that isn't actually unique. Here's how to find and fix the duplicates.
DAX Time Intelligence Cheat Sheet
A fast, scannable reference for the DAX time intelligence functions you'll actually reach for — YTD, prior period, and period-over-period comparisons.
How to Fix a Circular Dependency Error in DAX
"A circular dependency was detected" usually comes from a calculated column, not a measure. Here's how to find the cycle and break it.
Power Query Error: Expression.Error - The Field Wasn't Found
This error means a step is referencing a column name that doesn't exist by the time it runs. Here's how to find which step, and the four usual causes.