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 )
Related functions
Other functions related to BinaryFormat.Record are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy