keep_errors
Retain only rows that contain errors in Power Query tables, optionally for selected columns. Enables inspection and correction of bad data.
Instructions
Power Query Keep Errors: keep ONLY rows that carry an error value (to inspect bad data). Appends Table.SelectRowsWithErrors to the table's M query. Pass columns (comma-separated) to test only those columns; omit for the whole row.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| columns | No | columns to test for errors, comma-separated (omit for whole row) | |
| sessionId | Yes | ||
| partitionName | No | partition name (optional; defaults to the first partition) |