Binary.Decompress

Unpacks a binary value by utilizing the specified compression method. The output of this operation is an uncompressed duplicate of the original input. Supported compression methods are Compression.GZi...

Syntax

Binary.Decompress(binary as nullable binary, compressionType as number) as nullable binary

About

Unpacks a binary value by utilizing the specified compression method. The output of this operation is an uncompressed duplicate of the original input. Supported compression methods are Compression.GZip and Compression.Deflate.

Explanation

Unpack a compressed binary value using Power Query M function MBinary.Decompress(). The input binary value is #binary({115, 103, 200, 7, 194, 20, 134, 36, 134, 74, 134, 84, 6, 0}), compressed with the Deflate algorithm. The output will be #binary({71, 0, 111, 0, 111, 0, 100, 0, 98, 0, 121, 0, 101, 0}).