Forum Discussion
Trouble Extracting CSV from Zipped Directory on Web Using Power Query
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,
sorry forget my last message, I realized that I was wrong, I used a link to my hard drive 🙂
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,
Thank you so much ibarrau and also @Greg_Deckler to connect us, it works!!!! It wasn't simple at all and far beyond my skills as a beginner in Power BI. If I understand correctly, this means I'll face a similar trouble with XML files from French government too if compression steps aren't recognized by Power Query.