Forum Discussion
Solved
Combine files in a folder (Get Data)
Hi. I have a folder of many .csv files, that I want to combine into one table. My problem is that when it gets combined, it simply repeats the headers as the combined data. I can't figure out wh...
1. I hope you are following below steps. First go to New Source and then select Folder
2. Then below window will appear please select combine and trasnform data option
3. In third screen select the source sheet and click on ok. PowerBi automatically will combine files with including header from each file.
hi Unicorn_Tech
For your case, you could just create a simple power query function like below to get it
A cleaner way to import files from a SharePoint folder with a Power Query function
Regards,
Lin