Forum Discussion
Unicorn_Tech
Resolver I
Resolver ICombine 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.
Unicorn_TechResolver I
Resolver IHi negi007
Thank you for the pictures and steps. I had been doing it correctly, apparently, but the first folder I wanted to apply it to, didn't combine properly. Skipping this folder, and following your steps, is letting me combine it.
negi007
Community Champion
Community ChampionUnicorn_Tech please mark my response as solution if has helped you in resolving the issue and also to close the thread.