Forum Discussion

jaryszek's avatar
jaryszek
Super User
1 year ago

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

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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    1 year ago

    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's avatar
      jaryszek
      Super User
      1 year ago

      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