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:

BI Gorilla Blog

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation:
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.