Forum Discussion
Open CSV in Zip file with M Query but returning 0kb
Hi all,
I'm trying to bring this dataset in.
https://open.canada.ca/data/en/dataset/12f07737-3508-4962-aebd-5bcfc73214b1/resource/c50836fb-6432-47e7-893a-3a144847284b?inner_span=True
And I have followed the instruction here to extract the file
https://curbal.com/curbal-learning-portal/get-data-from-zip-files-in-power-query#:~:text=In%20today's%20video%2C%20I%20will,having%20to%20extract%20them%20first.
But it showed 0kb and no data loaded.
Could you please help to overc
2 Replies
- adudani
Memorable Member
hi Anonymous ,
in the source step i get that data is present in the zip however,
I get the following error using the blog post when expanding the zip in the last step.
I think it's because the function is not handling "Semicolon" separtor of the csv file.
Alternatively, you could extract the file and get data from the .csv file.
Thanks, adudani.
I had to use the extraction method to get the data in and realized the semicolon issue as well.
I tried with SDMX as guided here.
https://learn.microsoft.com/en-us/power-query/connectors/sis-cc-sdmx
with this link:
But it doesn't work.
