Forum Discussion

AwatefM's avatar
AwatefM
Frequent Visitor
2 years ago
Solved

Trouble Extracting CSV from Zipped Directory on Web Using Power Query

I want to import the file "GeolocalisationEtablissement_Sirene_pour_etudes_statistiques_utf8.csv", which is regularly updated on the French government website. I can directly download the URL of th...
Need Help
  • ibarrau's avatar
    ibarrau
    2 years ago

    Hi Greg, thanks for reaching. The file seems to have a compression that's not allowed by the methods in the power query script. Zips have several settings for compression that makes kind of difficult to create a function that works for almost all of them. They way your file looks like should work with this alternativa function for extracting:

    https://github.com/Michael19842/PowerBiFunctions/blob/main/ZipFile/Unzip.m

    Remember this function only extracts. The interpretation of the file inside it's a different thing.

    I hope that helps,

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

AwatefM From my testing, it appears as if the binary contents aren't being extracted correctly. Will try to troubleshooting and see what is going on.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

AwatefM Interesting. If I download the file and use File.Contents instead of Web.Contents everything seems to work using the unzip function. ibarrau any insights into why this doesn't seem to work with Web.Contents?