Forum Discussion
Responsive ResidentOpen zip file from a web url
I wish to be able to import and extract from.
This sort of thing doesnt work:
let
Source = Web.Contents("https://www.propertypriceregister.ie/website/npsra/ppr/npsra-ppr.nsf/Downloads/PPR-ALL.zip/$FILE/PPR-ALL.zip"),
Decompress = Binary.Decompress(Source, Compression.GZip)
in
Decompress
Any ideas?
Hi StephenF
You can try the function provided in the following blog.
http://sql10.blogspot.com/2016/06/reading-zip-files-in-powerquery-m.html
I have tested it with your link. The sample pbix is at bottom.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
2 Replies
v-jingzhangCommunity Support
Hi StephenF
You can try the function provided in the following blog.
http://sql10.blogspot.com/2016/06/reading-zip-files-in-powerquery-m.html
I have tested it with your link. The sample pbix is at bottom.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.- StephenF
Perfect, all it needs is to be an out of the box connector type.
