Forum Discussion
ktt777
Helper V
Helper VLoading 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 tabl...
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.