BinaryFormat.Record

Updated on

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

Syntax

BinaryFormat.Record( record as record ) as function

Description

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.

Examples

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

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

Other functions related to BinaryFormat.Record are:

BI Gorilla Youtube Channel

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