decompressing gz. Json files from a folder

[Alirezam]

Hi guys,

I have a folder containing gz files which are literally JSON compressed files. I need to combine them into one file during the transformation process in Power Query. Any idea will be appreciated. This is the folder 

[V-pazhen-msft]

@Alirezam 

check solved posts regarding to this quesiton:

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

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

You may also follow the step-by-step tutorial.

Decompress gzip files using Power BI and get access to @EU_Eurostat data. - YouTube

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Alirezam]

Thanks Unfortunately none of those links solved my problem and I had read them before. My problem is reading from a folder, not from just one file. I could not find any solution here. I provided the link if you can find a way to open them please let me know. thanks

[Wesleybarton]

Did you ever find a solution to this?