Binary functions
The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference.
Reading numbers
| Function | Description |
|---|---|
| BinaryFormat.7BitEncodedSignedInteger | A binary format that reads a 64-bit signed integer that was encoded using a 7-bit variable-length encoding. |
| BinaryFormat.7BitEncodedUnsignedInteger | A binary format that reads a 64-bit unsigned integer that was encoded using a 7-bit variable-length encoding. |
| BinaryFormat.Binary | Returns a binary format that reads a binary value. |
| BinaryFormat.Byte | A binary format that reads an 8-bit unsigned integer. |
| BinaryFormat.Choice | Returns a binary format that chooses the next binary format based on a value that has already been read. |
| BinaryFormat.Decimal | A binary format that reads a .NET 16-byte decimal value. |
| BinaryFormat.Double | A binary format that reads an 8-byte IEEE double-precision floating point value. |
| BinaryFormat.Group | Returns a binary format that reads a group of items. Each item value is preceded by a unique key value. The result is a list of item values. |
| BinaryFormat.Length | Returns a binary format that limits the amount of data that can be read. Both BinaryFormat.List and BinaryFormat.Binary can be used to read until end of the data. BinaryFormat.Length can be used to limit the number of bytes that are read. |
| BinaryFormat.List | Returns a binary format that reads a sequence of items and returns a list. |
| BinaryFormat.Null | A binary format that reads zero bytes and returns null. |
| BinaryFormat.Record | Returns a binary format that reads a record. Each field in the record can have a different binary format. |
| BinaryFormat.SignedInteger16 | A binary format that reads a 16-bit signed integer. |
| BinaryFormat.SignedInteger32 | A binary format that reads a 32-bit signed integer. |
| BinaryFormat.SignedInteger64 | A binary format that reads a 64-bit signed integer. |
| BinaryFormat.Single | A binary format that reads a 4-byte IEEE single-precision floating point value. |
| BinaryFormat.Text | Returns a binary format that reads a text value. The optional encoding value specifies the encoding of the text. |
| BinaryFormat.Transform | Returns a binary format that will transform the values read by another binary format. |
| BinaryFormat.UnsignedInteger16 | A binary format that reads a 16-bit unsigned integer. |
| BinaryFormat.UnsignedInteger32 | A binary format that reads a 32-bit unsigned integer. |
| BinaryFormat.UnsignedInteger64 | A binary format that reads a 64-bit unsigned integer. |
| Controlling byte order | Description |
|---|---|
| BinaryFormat.ByteOrder | Returns a binary format with the byte order specified by a function. |
| Table.PartitionValues | Returns information about how a table is partitioned. |
| Function | Description |
|---|---|
| Binary.Buffer | Buffers the binary value in memory. The result of this call is a stable binary value, which means it will have a deterministic length and order of bytes. |
| Binary.Combine | Combines a list of binaries into a single binary. |
| Binary.Compress | Compresses a binary value using the given compression type. |
| Binary.Decompress | Decompresses a binary value using the given compression type. |
| Binary.End | Returns a binary value corresponding to the end of binary. The returned value is always empty (i.e. it is 0 bytes in length). |
| Binary.From | Returns a binary value from the given value. |
| Binary.FromList | Converts a list of numbers into a binary value |
| Binary.FromText | Decodes data from a text form into binary. |
| Binary.Length | Returns the length of binary values. |
| Binary.ToList | Converts a binary value into a list of numbers |
| Binary.ToText | Encodes binary data into a text form. |
| BinaryEncoding.Base64 | Constant to use as the encoding type when base-64 encoding is required. |
| BinaryEncoding.Hex | Constant to use as the encoding type when hexadecimal encoding is required. |
| BinaryOccurrence.Optional | The item is expected to appear zero or one time in the input. |
| BinaryOccurrence.Repeating | The item is expected to appear zero or more times in the input. |
| BinaryOccurrence.Required | The item is expected to appear once in the input. |
| ByteOrder.BigEndian | A possible value for the byteOrder parameter in BinaryFormat.ByteOrder. The most signficant byte appears first in Big Endian byte order. |
| ByteOrder.LittleEndian | A possible value for the byteOrder parameter in BinaryFormat.ByteOrder. The least signficant byte appears first in Little Endian byte order. |
| Compression.Deflate | The compressed data is in the 'Deflate' format. |
| Compression.GZip | The compressed data is in the 'GZip' format. |
| Occurrence.Optional | The item is expected to appear zero or one time in the input. |
| Occurrence.Repeating | The item is expected to appear zero or more times in the input. |
| Occurrence.Required | The item is expected to appear once in the input. |
Show: