Load multiple .gz files from multiple folders in Power BI

[ShanShami]

Hello All,
I have multiple folders which contains multiple .gz files. I want to load all these files in Power BI and prepare reports.
Can you please assist me to understand how to link these folders in Power BI and unzipped the data.

Below each subfolder has multiple .gz files.

Main Folder ABC
-Folder 1
-Folder 2
-Folder 3
.
.
.
.
.
.
- Folder N

 

[GraH - Guido]

I do not think there is a connector to .gz files. You would need to unzip upfront. The structure can be as in your example, different folders under a main one. Then in PowerBI connect to that main folder.

 

[GraH - Guido]

You can have a go with this video

 

[ShanShami]

Thank you.