Table.InsertRows

Syntax

Table.InsertRows(table as table, offset as number, rows as list) as table

Description

Returns a table with the list of rows, rows, inserted into the table at the given position, offset. Each column in the row to insert much match the column types of the table.

Reference Data

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

Power Query M Functions / Table Functions / Table.InsertRows