Why PQ create transform file from Quary ?

[admin11]

Hi All

[mhossain · Accepted solution]

@admin11 

I guess you are  connecting to a folder to combine all the files, Power Query creates a query called 'Sample file', which is used as example to process each file. And other queries also created as per your transform logic, if you remove it, your combining file logic will be broken.

Hope this makes sense.

[admin11]

@mhossain 

Thank you very much for sharing .  it help a lot.

Paul