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 ...
Need Help
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