BinaryFormat.Record
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Returns a binary format that reads a record. Each field in the record can have a different binary format.
BinaryFormat.Record(record as record) as function
| Argument | Description |
|---|---|
| record | The format of the record |
- 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.
let
binaryData = #binary({
0x00, 0x01,
0x00, 0x00, 0x00, 0x02}),
recordFormat = BinaryFormat.Record([
A = BinaryFormat.UnsignedInteger16,
B = BinaryFormat.UnsignedInteger32
])
in
recordFormat(binaryData)
equals [A = 1, B = 2]
Show: