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


List.Buffer( list as list ) as list


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


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: