Forum Discussion
Combine files in a folder (Get Data)
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.
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 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.
Unicorn_Tech please mark my response as solution if has helped you in resolving the issue and also to close the thread.