Replace Errors with Null in Power Query M

Notes

List every column you want error-checked as an extra {"ColumnName", null} pair.

Requirements

• A table with a column that may produce row-level errors.

How to use this snippet

1. In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

• Replace Errors in All ColumnsReplaces error values with null across every column in a table, without listing columns individually.
• Handle Missing or Invalid Data SafelyWraps a calculation so an error or missing value falls back to a default instead of failing the query.
• Remove Error RowsRemoves any row where a given column contains an error value, instead of replacing the error.
• Convert a Column to Whole Number SafelyConverts a column to Int64, replacing any value that fails to convert with null instead of erroring the whole query.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Replace Errors with Null.