Table.ReplaceRows

Table.ReplaceRows is a Power Query M function that replaces a specified number of rows in the input table with new rows, starting after the specified offset. The function returns a table with the replaced rows.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

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.

• table: The table where the replacement is performed.
• offset: The number of rows to skip before making the replacement.
• count: The number of rows to replace.
• rows: The list of row records to insert into the table at the location specified by the offset.

Examples

Starting at position 1, replace 3 rows.

Table.ReplaceRows( 
    Table.FromRecords( {
        [Column1 = 1],
        [Column1 = 2],
        [Column1 = 3],
        [Column1 = 4],
        [Column1 = 5]
    } ),
    1,
    3,
    {[Column1 = 6], [Column1 = 7]}
 )

 /* Output: 
Table.FromRecords( {
    [Column1 = 1],
    [Column1 = 6],
    [Column1 = 7],
    [Column1 = 5]
} )
 */ 

Related functions

Other functions related to Table.ReplaceRows are:

• Table.ReplaceRelationshipIdentity

Last update: August 28, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/table-replacerows
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.