remove_errors
Clean Power BI data by dropping rows that contain errors. Specify columns to test only those, or omit to scan the entire row.
Instructions
Power Query Remove Errors: drop rows that carry an error value. Appends Table.RemoveRowsWithErrors to the table's M query. Pass columns (comma-separated) to test only those columns; omit to test 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) |