Merge all *.pg files into one .m script using powershell

[jaryszek]

Hi Guys,

i want to take all my .pq files and merge them into one .m script using powershell.

Maybe do you have a sample code to do this? 

After merging i can use it within my template power bi file...
Best,
Jacek

[amitchandak]

@jaryszek , In power query, you can copy paste code into power query

or Save the files in pbip/b format and then you can use code to merge the folder data where you have power query code.

[jaryszek]

thanks i do not want to copy and paste them manually, this why i created this post. 

I want to move all my *.pq files into power bi desktop report automatically. 

Thanks for help,
Jacek