Binary.Compress

This function compresses a binary value using the specified compression type. The output of this function will be a compressed version of the input data. Supported compression types are Compression.GZ...

Syntax

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

About

This function compresses a binary value using the specified compression type. The output of this function will be a compressed version of the input data. Supported compression types are Compression.GZip and Compression.Deflate.

Explanation

Utilize the Power Query function "MBinary.Compress" to reduce the size of the binary value. In this example, we are compressing a binary value created from a list that repeats the number 10 1000 times using the Deflate compression method. The output after compression is the binary value shown: #binary({227, 226, 26, 5, 163, 96, 20, 12, 119, 0, 0}).