Using Get Data from Folder with multiple files, does merging the files keep only one header?

[nmyre]

I have 6 files, each with the same headers. I would like to keep them in the same folder and use the Folder option to Get Data. However I only would like to keep one header. The data is updated daily and the number of rows change. Is this possible?

-N

[v-jingzhang · Accepted solution]

Hi @nmyre 

Yes, you can only keep one header. Please follow the steps in images. There are some points need to note:

• Select a sample file in the folder when combining files.
• After combining files, select Transform Sample File in the Queries and make sure that the first row has been used as headers.

Then you can select the combined query to check that no other header rows exist in the table. You can remove the Source.Name column if you don't need it.

Hope this helps,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[Ashish_Mathur]

Hi,

Watch this video - https://www.youtube.com/watch?v=yL11ugShdrk.

[camargos88]

@nmyre ,

Check this link: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-combine-binaries

It combines all the files using an example (mostly the first file). So it appends all the tables without duplicate the headers.