Open CSV in Zip file with M Query but returning 0kb

[Anonymous]

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-4...

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'....

But it showed 0kb and no data loaded.
Could you please help to overc

[adudani]

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.

[Anonymous]

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.