Keep Only Error Rows (for debugging) in Power Query M

Keeps only the rows where a given column contains an error, to inspect and fix bad source data.

Error HandlingBeginnererrorsdebuggingrows

Power Query M code

let
    Source = YourTable,
    OnlyErrors = Table.SelectRows(Source, each (try [ColumnName])[HasError] = true)
in
    OnlyErrors

Notes

Combine with Table.AddColumn to add an ErrorReason column using (try [ColumnName])[Error][Message] for more detail.

Requirements

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

How to use this snippet

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).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Keep Only Error Rows (for debugging).