BinaryFormat.Binary

BinaryFormat.Binary is a Power Query M function that reads a binary value with an optional specified length. The function returns a binary value containing either the specified number of bytes or the remaining bytes if the length is not specified.

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

Syntax

BinaryFormat.Binary( optional length as any ) as function

Description

Returns a binary format that reads a binary value. If length is specified, the binary value will contain that many bytes. If length is not specified, the binary value will contain the remaining bytes. The length can be specified either as a number, or as a binary format of the length that precedes the binary data.

Related functions

Other functions related to BinaryFormat.Binary are:

• BinaryFormat.Group
• BinaryFormat.List
• BinaryFormat.Record

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