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.