Press "Enter" to skip to content

Power Query And Power BI Compression

Chris Webb shows us how to work with gzip files using PowerQuery:

For example, given a gzip file that contains a single csv file, here’s an example M query showing how the Binary.Decompress() function can be used to extract the csv file from the gzip file and then treat the contents of the csv file as a table:

He goes on ot show how Binary.Decompress is used to read Excel XLSX files.