List.Buffer

Updated on

List.Buffer is a Power Query M function that stores a given list in memory, creating a stable list. The function returns a buffered version of the input list.

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

Syntax

List.Buffer( list as list ) as list

Description

Buffers the list list in memory. The result of this call is a stable list.

Examples

Create a stable copy of the list {1..10}.

// Output: {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}
List.Buffer( {1..10} )

Learn more about List.Buffer in the following articles:

Other functions related to List.Buffer are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/list-buffer