The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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:
http://sql10.blogspot.com/2016/06/reading-zip-files-in-powerquery-m.html
http://www.excelandpowerbi.com/?p=155
Regards,
Jimmy Tao
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:
http://sql10.blogspot.com/2016/06/reading-zip-files-in-powerquery-m.html
http://www.excelandpowerbi.com/?p=155
Regards,
Jimmy Tao
User | Count |
---|---|
74 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
51 | |
48 | |
48 |