Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I need help to solve this problem.
I have this source:
http://res1104.se.gob.ar/adjuntos/precios_eess_2013_en_adelante.zip
I use WEB SOURCE to connect the file and I can't decompress it. My code is this:
let
Source = Web.Contents("http://res1104.se.gob.ar/adjuntos/precios_eess_2013_en_adelante.zip"),
Decompress = Binary.Decompress(Source, Compression.GZip)
in
Decompress
The error PowerQuery show me is:
DataFormat.Error: The magic number in GZip header is not correct. Make sure you are passing in a GZip stream.
How can I do to solve it?
Thanks a lot.
Solved! Go to Solution.
Looks like it is not a GZip format. You can replace Compression.GZip with one of the other compression types. Just start typing Compression to see the options (if intellisense is enabled in your file).
If one of those doesn't work, you can try the custom function described in this article.
Reading Zip files in PowerQuery / M (sql10.blogspot.com)
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @Anonymous ,
Modify the M code as below:
let
Source = Web.Contents("http://res1104.se.gob.ar/adjuntos/precios_eess_2013_en_adelante.zip",[Headers=[#"Accept-Encoding"="gzip"]]),
Decompress = Binary.Decompress(Source, Compression.GZip)
in
Decompress
Check the similar thread below:
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Looks like it is not a GZip format. You can replace Compression.GZip with one of the other compression types. Just start typing Compression to see the options (if intellisense is enabled in your file).
If one of those doesn't work, you can try the custom function described in this article.
Reading Zip files in PowerQuery / M (sql10.blogspot.com)
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.