Table.ReplaceRows

Syntax

Table.ReplaceRows(table as table, offset as number, count as number, rows as list) as table

Description

Replaces a specified number of rows, count, in the input table with the specified rows, beginning after the offset. The rows parameter is a list of records.

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / Table Functions / Table.ReplaceRows