Forum Discussion
Solved
Combine data from multiple excel file into one
I have run out of rows in my excel file. I started a new excel file with the same table but with new data. I need data from both these files in my data model. How can I do that? Thank...
Hello Vishesh,
I've created an example that you can download from my onedrive.
You will find images with the steps (1 to 4), a folder with both excel files, and the pbix file 😄
If you experience any more dificulties, please tell.
Regards,
Salvador.
Use a Folder query and put both files in the same folder.
Alternatively, you could use an Append query.
Hi smoupre,
Thanks for replying.
I did use Append queries and it did the work I wanted to do.
However, I still don't know how to use Folder query, so if you could please explain that.
Thank you,
Vishesh Jain
