Zip file from web source

Hi Kristan,

 

I understand your requirement but I'm afraid Web.Contents() only support import data from DOM tree of one website. So we could only achieve the .zip files' name list with this function. As a workaround, I would recommend you to save these files firstly using R or python script and Unzip these compressed files in power query. For more details, please refer to similar cases below:

https://community.powerbi.com/t5/Integrations-with-Files-and/Download-and-unzip-multiple-files-from-URL-then-query-csv-file-s/td-p/91872

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

http://www.excelandpowerbi.com/?p=155

 

Regards,

Jimmy Tao