Updated on

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


BinaryFormat.Binary( optional length as any ) as function


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.

Other functions related to BinaryFormat.Binary are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: