Solved: Open zip file from a web url

StephenF · ‎09-13-2022

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..."),
Decompress = Binary.Decompress(Source, Compression.GZip)
in
Decompress

Any ideas?

v-jingzhang · ‎09-13-2022

You can try the function provided in the following blog.

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.

v-jingzhang · ‎09-13-2022

You can try the function provided in the following blog.

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 · ‎09-14-2022

Perfect, all it needs is to be an out of the box connector type.

Open zip file from a web url