Zip file from web source

[Kristan]

Hi all,

Is there a way to import a zip file directly from the web?  Instead of downloading the zip file and then using the folder location as the data source.

Many thanks,

Kristan

[v-yuta-msft · Accepted solution]

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-...

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

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

Regards,

Jimmy Tao