Forum Discussion
Combining Multiple Files From Folder With Multiple Sheets
Dear Community, Hope my message finds you well and healthy! I would like to combine multiple files from folder where each file contains multiple sheets like so: At the end I woul...
Get Data from Multiple Excel Files with Different Sheet Names into Power BI - RADACAD
You could have gone to the site and scrolled through the articles just as easily as I did.
RADACAD has a post about getting data from multiple sheets in Excel.
I think you should be able to combine that with getting data from FOLDERS as well, so it includes ALL sheets of EVERY file.
Thanks, can you pull the actual link for the article?