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
- beginner~7 minPro
Remove rows whose quantity isn't a number (kite shop)
Typing Qty as a whole number turns placeholders like n/a into errors. Remove those rows.
- intermediate~8 minPro
Replace bad quantities with null and flag them (kite shop)
Keep every order, but turn unreadable quantities into null and add a Needs Review flag.
- intermediate~7 minPro
List the rows whose amount can't be converted (travel)
Before cleaning, finance wants an audit list of claims whose Amount isn't a number, with the original text.
- intermediate~8 minPro
Replace conversion errors with a different value per column (garden centre)
After typing, bad Discount values should become 0 and bad Price values null. One step can do both.