keep_range_rows
Skip offset rows and keep a specified count of rows in a Power BI table by appending Table.Range to the M query.
Instructions
Power Query Keep Range of Rows: skip offset rows then keep count rows. Appends Table.Range to the table's M query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| count | Yes | number of rows to keep | |
| table | Yes | ||
| offset | Yes | rows to skip before the range starts | |
| sessionId | Yes | ||
| partitionName | No | partition name (optional; defaults to the first partition) |