BinaryFormat.Record is a Power Query M function that reads a record from a binary format. The record parameter specifies the format of the record, and each field can have a different binary format. It returns the record read from the binary format.

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


BinaryFormat.Record( record as record ) as function


Returns a binary format that reads a record. The record parameter specifies the format of the record. Each field in the record can have a different binary format. If a field contains a value that is not a binary format value, then no data is read for that field, and the field value is echoed to the result.


Read a record containing one 16-bit integer and one 32-bit integer.

// Output: [A = 1, B = 2]
    binaryData = #binary( {
        0x00, 0x01,
        0x00, 0x00, 0x00, 0x02
    } ),
    recordFormat = BinaryFormat.Record( [
        A = BinaryFormat.UnsignedInteger16,
        B = BinaryFormat.UnsignedInteger32
    ] )
    recordFormat( binaryData )

Other functions related to BinaryFormat.Record are:

BI Gorilla Youtube Channel

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