Binary Functions
BinaryFormat.Group
Syntax BinaryFormat.Group(binaryFormat as function, group as list, optional extra as nullable function, optional lastKey as …
BinaryFormat.Text
Syntax BinaryFormat.Text(length as any, optional encoding as nullable number) as function Description Returns a binary …
Table.PartitionValues
Syntax Table.Partition(table as table, column as text, groups as number, hash as function) as list …
Binary.FromList
Syntax Binary.FromList(list as list) as binary Description Converts a list of numbers into a binary …
BinaryFormat.Decimal
Syntax BinaryFormat.Decimal(binary as binary) as any Description A binary format that reads a .NET 16-byte …
BinaryFormat.List
Syntax BinaryFormat.List(binaryFormat as function, optional countOrCondition as any) as function Description Returns a binary format …
Binary.Combine
Syntax Binary.Combine(binaries as list) as binary Description Combines a list of binaries into a single …
Binary.From
Syntax Binary.From(value as any, optional encoding as nullable number) as nullable binary Description Returns a …
BinaryFormat.ByteOrder
Syntax BinaryFormat.ByteOrder(binaryFormat as function, byteOrder as number) as function Description Returns a binary format with …
Occurrence.Optional
Syntax null Description The item is expected to appear zero or one time in the …
Binary.ToList
Syntax Binary.ToList(binary as binary) as list Description Converts a binary value into a list of …
Compression.Deflate
Syntax null Description The compressed data is in the ‘Deflate’ format. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power …
BinaryFormat.SignedInteger32
Syntax BinaryFormat.SignedInteger32(binary as binary) as any Description A binary format that reads a 32-bit signed …
BinaryFormat.Null
Syntax BinaryFormat.Null(binary as binary) as any Description A binary format that reads zero bytes and …
Binary.ToText
Syntax Binary.ToText(binary as nullable binary, optional encoding as nullable number) as nullable text Description Returns …
BinaryFormat.SignedInteger64
Syntax BinaryFormat.SignedInteger64(binary as binary) as any Description A binary format that reads a 64-bit signed …
BinaryFormat.7BitEncodedUnsignedInteger
Syntax BinaryFormat.7BitEncodedUnsignedInteger(binary as binary) as any Description A binary format that reads a 64-bit unsigned …
Compression.GZip
Syntax null Description The compressed data is in the ‘GZip’ format. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power …
BinaryFormat.Byte
Syntax BinaryFormat.Byte(binary as binary) as any Description A binary format that reads an 8-bit unsigned …
ByteOrder.BigEndian
Syntax null Description A possible value for the byteOrder parameter in BinaryFormat.ByteOrder. The most significant …
BinaryFormat.Length
Syntax BinaryFormat.Length(binaryFormat as function, length as any) as function Description Returns a binary format that …
Binary.Compress
Syntax Binary.Compress(binary as nullable binary, compressionType as number) as nullable binary Description Compresses a binary …
Binary.Decompress
Syntax Binary.Decompress(binary as nullable binary, compressionType as number) as nullable binary Description Decompresses a binary …
Binary.InferContentType
Syntax Binary.InferContentType(source as binary) as record Description Returns a record with field Content.Type that contains …
BinaryFormat.Single
Syntax BinaryFormat.Single(binary as binary) as any Description A binary format that reads a 4-byte IEEE …
BinaryOccurrence.Required
Syntax null Description The item is expected to appear once in the input. Reference Data …
BinaryFormat.7BitEncodedSignedInteger
Syntax BinaryFormat.7BitEncodedSignedInteger(binary as binary) as any Description A binary format that reads a 64-bit signed …
BinaryFormat.UnsignedInteger32
Syntax BinaryFormat.UnsignedInteger32(binary as binary) as any Description A binary format that reads a 32-bit unsigned …
BinaryFormat.SignedInteger16
Syntax BinaryFormat.SignedInteger16(binary as binary) as any Description A binary format that reads a 16-bit signed …
BinaryEncoding.Hex
Syntax null Description Constant to use as the encoding type when hexadecimal encoding is required. …
BinaryFormat.Double
Syntax BinaryFormat.Double(binary as binary) as any Description A binary format that reads an 8-byte IEEE …
BinaryOccurrence.Optional
Syntax null Description The item is expected to appear zero or one time in the …
Occurrence.Repeating
Syntax null Description The item is expected to appear zero or more times in the …
BinaryFormat.Choice
Syntax BinaryFormat.Choice(binaryFormat as function, chooseFunction as function, optional type as nullable type, optional combineFunction as …
Binary.Buffer
Syntax Binary.Buffer(binary as nullable binary) as nullable binary Description Buffers the binary value in memory. …
ByteOrder.LittleEndian
Syntax null Description A possible value for the byteOrder parameter in BinaryFormat.ByteOrder. The least significant …
BinaryOccurrence.Repeating
Syntax null Description The item is expected to appear zero or more times in the …
Occurrence.Required
Syntax null Description The item is expected to appear once in the input. Reference Data …
BinaryFormat.UnsignedInteger64
Syntax BinaryFormat.UnsignedInteger64(binary as binary) as any Description A binary format that reads a 64-bit unsigned …
BinaryFormat.UnsignedInteger16
Syntax BinaryFormat.UnsignedInteger16(binary as binary) as any Description A binary format that reads a 16-bit unsigned …
BinaryFormat.Record
Syntax BinaryFormat.Record(record as record) as function Description Returns a binary format that reads a record. …
#binary
Syntax #binary(value as any) as any Description Creates a binary value from a list of …
Binary.Length
Syntax Binary.Length(binary as nullable binary) as nullable number Description Returns the number of characters. Reference …
Binary.FromText
Syntax Binary.FromText(text as nullable text, optional encoding as nullable number) as nullable binary Description Returns …
BinaryEncoding.Base64
Syntax null Description Constant to use as the encoding type when base-64 encoding is required. …
BinaryFormat.Transform
Syntax BinaryFormat.Transform(binaryFormat as function, function as function) as function Description Returns a binary format that …
BinaryFormat.Binary
Syntax BinaryFormat.Binary(optional length as any) as function Description Returns a binary format that reads a …