Importing .gz file into PowerBi how to do this

Hi jaryszek 
This post suggests you can do it from Azure.
https://community.fabric.microsoft.com/t5/Desktop/Importing-gz-file-into-PowerBi/td-p/4592960
I can't confirm that but I've attached an example of a csv compressed to gaz.

 

I've attached the csv as a zip as gz and csv aren't supported on this platform.

Hi jaryszek,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Power BI Desktop and Power Query do not natively read .gz files directly, they can read the uncompressed data inside like .csv or .json. Power bi can load a .gz file directly if it is a standard gzip-compressed csv.

• Open Power BI Desktop --> Get data --> Blank query. In the query editor choose Advanced Editor and paste the below M code:
  

  let

      Source = File.Contents("file path"),

      Decompressed = Binary.Decompress(Source, Compression.GZip),

      CSV = Csv.Document(Decompressed, [Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.Csv])

  in

      CSV

• Update the file path to the .gz file and click Done.

This decompresses the .gz and parses the csv in one step without needing external tools. If the .gz contains something other than a single csv file like for example .tar.gz archive, it must be extracted before importing into power bi.

 

 

If this post helps in resolving the issue, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thanks and regards,

Anjan Kumar Chippa