Forum Discussion
rajaaben
9 years agoRegular Visitor
Combine multiple excel files into one
Hello everyone, I'm new in Power PI I have many excel files with the same headers that i need to combine into one using power bi to be able to make my dashboard. The solution that i found and with...
- 9 years ago
Hello,
Thanks for your answers.
I solved my problem using this video : https://www.youtube.com/watch?v=a7E29H5ZUmE
i did it on PowerBi PowerQuery instead of Excel PowerQuery. while following the steps i got some _FilterDatabase lines that i had to delete.
Marianarosa
8 years agoNew Member
Hi.
I may have a product, that can help you. Sheetgo does that connection for you. You can connect multiple sheets in one, and even choose if you want to the update automatically. Among other features that can be very helpful.
would like to invite you to try it on
Regards
Mariana