keep_top_rows
Keep only the first N rows of a table in Power Query by appending Table.FirstN to the M query.
Instructions
Power Query Keep Top Rows: keep only the first N rows. Appends Table.FirstN to the table's M query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| count | Yes | number of rows to keep from the top | |
| table | Yes | ||
| sessionId | Yes | ||
| partitionName | No | partition name (optional; defaults to the first partition) |