Table.Repeat

Syntax

Table.Repeat(table as table, count as number) as table  

About

Returns a table with the rows from the input table repeated the specified count times.

Example 1

Repeat the rows in the table two times.

Usage

Power Query M

Table.Repeat(
    Table.FromRecords({
        [a = 1, b = "hello"],
        [a = 3, b = "world"]
    }),
    2
)

Output

Power Query M

Table.FromRecords({
    [a = 1, b = "hello"],
    [a = 3, b = "world"],
    [a = 1, b = "hello"],
    [a = 3, b = "world"]
})