Zip file from web source

Question

Hi all,&nbsp;Is there a way to import a zip file directly from the web?&nbsp;&nbsp;Instead of&nbsp;downloading the zip file and then using the folder location as the data source.&nbsp;Many thanks,&nbsp;Kristan

v-yuta-msft · Accepted Answer

Hi&nbsp;Kristan,
&nbsp;
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
&nbsp;
Regards,
Jimmy Tao

Forum Discussion

Related content

swapping data source excel file?

Data source

Import multiple files from external source

excel source file

Export all source files