Power QueryExercises

Error value

A cell or value that records a failure, such as converting "n/a" to a number. Errors stay in their cell until a step needs the value.

A cell error doesn't stop the query until a step needs that value, so a column can hold a few errors while the rest loads. try … otherwise catches them in code, and Remove Errors or Replace Errors handle them for a whole column. Errors in a loaded table appear as blank cells in Excel with an error count in the Queries pane.

In the Power Query editor

Error cells show Error in red; clicking one shows the message at the bottom of the preview.

Learn more

Related functions

Practise it