How to read multiple GZip files from Azure Blob Storage

[neadhs]

Hi I'm trying to get data from Azure blob storage and which contains a folder with many GZip files.

I need a similar solution as in here, just for GZip:

http://sql10.blogspot.com/2016/06/reading-zip-files-in-powerquery-m.html

[Anonymous · Accepted solution]

Hi @neadhs ,

This video shows you how to access Eurostat open data using power bi. Most data is stored in gzip files and you need to know how to decompress gzip files to be able to get the data.

The link of video is: Decompress gzip files using Power BI and get access to @EU_Eurostat data.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

There are a lot of nuances, but in general Power Query supports gzip files natively. 

Binary.Decompress - PowerQuery M | Microsoft Docs

what size are your files, and are there multiple payloads?