Forum Discussion
Error opening .csv: DataFormat.Error: Block length does not match its plugin.
Microsoft artemus Hello everyone, I have this use case where I want to connect to a csv file. I obtain this file via API, and it comes compressed in .zip. I was able to make the connection and man...
Hi Anonymous, thanks for the answer. I tried what the blog indicates, but I couldn't get it to work.
1st I added the code #"Accept-Encoding" = "gzip" inside the Header in Web.Contents, but the error remained the same.
2nd I tried using Web.BrowserContents instead of Web.Contents, but I get an error with the header, like it doesn't support it:
3rd I tried decompressing the binary content using the Binary.Decompress() function, and all the decompression formats but the error remained the same.
Greetings
Hi Anonymous , There I managed to see the .csv file, but apparently it has bzip2 compression. I couldn't find information on how to unzip it, do you know if this is possible from power query?
Greetings and thanks!