Archive

BinaryFormat.List

Syntax BinaryFormat.List(binaryFormat as function, optional countOrCondition as any) as function Description Returns a binary format that reads a sequence of items and returns a list. The binaryFormat parameter specifies the binary format of each item. There are three ways to determine the number of items… Read More »BinaryFormat.List

Binary.Combine

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

Binary.InferContentType

Syntax Binary.InferContentType(source as binary) as record Description Returns a record with field Content.Type that contains the inferred MIME-type. If the inferred content type is text/*, and an encoding code page is detected, then additionally returns field Content.Encoding that contains the encoding of the stream. If… Read More »Binary.InferContentType

Binary.Decompress

Syntax Binary.Decompress(binary as nullable binary, compressionType as number) as nullable binary Description Decompresses a binary value using the given compression type. The result of this call is a decompressed copy of the input. Compression types include: Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary… Read More »Binary.Decompress

Binary.Compress

Syntax Binary.Compress(binary as nullable binary, compressionType as number) as nullable binary Description Compresses a binary value using the given compression type. The result of this call is a compressed copy of the input. Compression types include: Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary… Read More »Binary.Compress

BinaryFormat.Length

Syntax BinaryFormat.Length(binaryFormat as function, length as any) as function Description 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… Read More »BinaryFormat.Length

ByteOrder.BigEndian

Syntax null Description A possible value for the byteOrder parameter in BinaryFormat.ByteOrder. The most significant byte appears first in Big Endian byte order. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Binary Functions / ByteOrder.BigEndian

BinaryFormat.Byte

Syntax BinaryFormat.Byte(binary as binary) as any Description A binary format that reads an 8-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.Byte

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

BinaryFormat.7BitEncodedUnsignedInteger

Syntax BinaryFormat.7BitEncodedUnsignedInteger(binary as binary) as any Description A binary format that reads a 64-bit unsigned 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.7BitEncodedUnsignedInteger