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 ...
adudani
Memorable Member
Memorable Memberhi 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.