Forum Discussion
How to read multiple GZip files from Azure Blob Storage
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
Hi Anonymous ,
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.
2 Replies
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?
Hi Anonymous ,
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.
