Archive

BinaryOccurrence.Required

Syntax null Description The item is expected to appear once in the input. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / BinaryOccurrence.Required

BinaryFormat.7BitEncodedSignedInteger

Syntax BinaryFormat.7BitEncodedSignedInteger(binary as binary) as any Description A binary format that reads a 64-bit signed integer that was encoded using a 7-bit variable-length encoding. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / BinaryFormat.7BitEncodedSignedInteger

BinaryFormat.Binary

Syntax BinaryFormat.Binary(optional length as any) as function Description Returns a binary format that reads a binary value. If length is specified, the binary value will contain that many bytes. If length is not specified, the binary value will contain the remaining bytes. The length can… Read More »BinaryFormat.Binary

BinaryFormat.Transform

Syntax BinaryFormat.Transform(binaryFormat as function, function as function) as function Description Returns a binary format that will transform the values read by another binary format. The binaryFormat parameter specifies the binary format that will be used to read the value. The function is invoked with the… Read More »BinaryFormat.Transform

BinaryEncoding.Base64

Syntax null Description Constant to use as the encoding type when base-64 encoding is required. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / BinaryEncoding.Base64

Binary.FromText

Syntax Binary.FromText(text as nullable text, optional encoding as nullable number) as nullable binary Description Returns the result of converting text value text to a binary (list of number). encoding may be specified to indicate the encoding used in the text value. The following BinaryEncoding values… Read More »Binary.FromText

Binary.Length

Syntax Binary.Length(binary as nullable binary) as nullable number Description Returns the number of characters. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / Binary.Length

#binary

Syntax #binary(value as any) as any Description Creates a binary value from a list of numbers or a base 64 encoded text value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / #binary

BinaryFormat.Record

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… Read More »BinaryFormat.Record

BinaryFormat.UnsignedInteger16

Syntax BinaryFormat.UnsignedInteger16(binary as binary) as any Description A binary format that reads a 16-bit unsigned integer. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / BinaryFormat.UnsignedInteger16