Forum Discussion
Loading multiple sheet from multiple excel file into Power BI
Hi All,
I have multiple excel files with multiple sheets from different sale location . Each sheet is data from different month of the year : Jan to Dec. All the data(Jan to Dec sheet) have table form and have the same format.
How can i load all the sheets from different files in 1 database set in power BI ?
thanks .
3 Replies
ktt777 there are tons of posts on this, here is link to few
https://www.youtube.com/watch?v=9sfCDCpWTfc
https://www.youtube.com/watch?v=GvKYUgka_4Y
https://www.youtube.com/watch?v=RAmSdxt863s
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem.
It is a token of appreciation! ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
If the excel files have the same schema, you can try combine them into a single logical table with Get Data from folder.
Please refer to this tutorial: https://radacad.com/power-bi-get-data-from-multiple-files-in-a-folder-on-onedrive-for-business-no-gateway-needed
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
