Binary.Buffer

Binary.Buffer is a Power Query M function that stores a binary value in memory, resulting in a stable binary value with a deterministic length and byte order. The function returns a buffered binary value.

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

Syntax

Binary.Buffer( binary as nullable binary ) as nullable binary

Description

Buffers the binary value in memory. The result of this call is a stable binary value, which means it will have a deterministic length and order of bytes.

Examples

Create a stable version of the binary value.

// Output: #binary( {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10} )
Binary.Buffer( Binary.FromList( {0..10} ) )

Other functions related to Binary.Buffer are:

BI Gorilla Blog

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