remove_blank_rows
Removes rows from a Power Query table where all fields are blank or null by appending a Table.SelectRows filter to the M query.
Instructions
Power Query Remove Blank Rows: drop rows where every field is blank (empty or null). Appends Table.SelectRows with the all-fields-non-blank predicate to the table's M query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| sessionId | Yes | ||
| partitionName | No | partition name (optional; defaults to the first partition) |