Data table not populating after unzipping .gz file

[Anonymous]

Hi Team,

I have a folder with n number of .gz files in it on my local system. I wanted to load the data in Power BI for visualisation. I used the 2 codes for reference and followed the steps as given from Mark White blog for Reading Zip files in PowerQuery / M (sql10.blogspot.com).

Everything worked fine till table creation, but when I expand the table it is showing me Table is empty. Please find below SS for reerence. I can see data when I import the file and open it in excel.

Please suggest / help.

[v-tangjie-msft]

Hi @Anonymous ,

Refer this blog , please try to use Binary.Decompress() function:

If that doesn't help, check out the solutions for similar posts below that might help:

https://www.youtube.com/watch?v=OzQ44gwi5Kw

https://www.youtube.com/watch?v=S_lgoF-MCm4

 Decompress and load multiple .gz files from multip... - Microsoft Power BI Community

 Decompress .gz file on Sharepoint to Power BI - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

Hi Neeko Tang,

The above code run perfectly for me, but just one more thing it is taking only 1 file at a time into consideration. I have a folder with mulltiple .gz files in it. 

I have to access n number of files so I need to provide a folder and it will auto take all the files in it.

Thanks in Advance

[v-tangjie-msft · Accepted solution]

Hi @Anonymous ,

Please refer to the reply @Ricardo this blog:

You can also refer to @Chris Webb's reply:

Or change your folder structure to:

Parent_folder

• Folder_A
  • Folder_A_1
    
    • file.gz
  • Folder_A_2
    • file.gz

And refer this:Solved: Decompress and load multiple .gz files from multip... - Microsoft Power BI Community

Solved: Unzip all the files - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution  to help the other members find it more quickly.