Forum Discussion
Solved
Get Data from Multiple Excel Files with multiples Sheet and separate each sheet by table
Hi guys, I need help to implement the load by multiples excel files from folder/SharePoint. I have a folder that contains a lot of excel file, all the excel files have the same structure (The sam...
twister8889 - I think you will need to have a Folder query for each of your sheets that you want as a table. ImkeF or edhans might know better.
twister8889 , you should be able to load like
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
and get new data
Now if need table for each table that would be like load one excel create the model and the get all other data appended.