Forum Discussion
Solved
Combine files
Dear all , I have number of files in a folder , in which every file is data for each day . Now my task I to combine these files and make a BI report . I am using get data from folder option , wh...
Sujit_Thakur - The key here is getting the Promoted Headers step into the correct query. The query you want to edit should be called Transform Sample File. Here is an example of the query you want to edit (below). Any steps that are in this query should be performed for each file in the folder.
Sujit_Thakur , Are you merging file. If you are merging. Then merge will take care of header ?
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Dear amitchandak ,
I am not mergibg , I am using get data and then selecting folder as a option and selecting a primary sheet type to extract data from all the files in folder
amitchandak nickyvv please help
