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: