Archive

BinaryFormat.SignedInteger64

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

Binary.ToText

Syntax Binary.ToText(binary as nullable binary, optional encoding as nullable number) as nullable text Description Returns the result of converting a binary list of numbers binary into a text value. Optionally, encoding may be specified to indicate the encoding to be used in the text value… Read More »Binary.ToText

BinaryFormat.Null

Syntax BinaryFormat.Null(binary as binary) as any Description A binary format that reads zero bytes and returns null. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / BinaryFormat.Null

BinaryFormat.SignedInteger32

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

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 Query M Functions / Binary Functions / Compression.Deflate

Binary.ToList

Syntax Binary.ToList(binary as binary) as list Description Converts a binary value into a list of numbers. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / Binary.ToList

Occurrence.Optional

Syntax null Description The item is expected to appear zero or one time in the input. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / Occurrence.Optional

Binary.From

Syntax Binary.From(value as any, optional encoding as nullable number) as nullable binary Description Returns a binary value from the given value. If the given value is null, Binary.From returns null. If the given value is binary, value is returned. Values of the following types can… Read More »Binary.From

BinaryFormat.ByteOrder

Syntax BinaryFormat.ByteOrder(binaryFormat as function, byteOrder as number) as function Description Returns a binary format with the byte order specified by binaryFormat. The default byte order is ByteOrder.BigEndian. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / BinaryFormat.ByteOrder

BinaryFormat.Single

Syntax BinaryFormat.Single(binary as binary) as any Description A binary format that reads a 4-byte IEEE single-precision floating point value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / BinaryFormat.Single