Power QueryExercises

Power Query errors and how to fix them

29 error messages, what each one means, how to find the step that raises it, and a fix you can check. Every example runs in our simulator on each build.

New to debugging? Start with the error triage guide.

Expression.Error

The query logic refers to something that isn't there, or combines values of the wrong type.

DataFormat.Error

A value couldn't be converted: usually a type change, a culture mismatch or placeholder text.

Expression.SyntaxError

The M code itself isn't valid, so nothing runs until it's fixed.