Loading excel files without combining their content.

[chlxco]

Hi community,

I was wondering if there is any way to load multiple excel files in a single query  WITHOUT combining them? Every file has its own table/columns/content (e.g. students.xlsx, Countries.xlsx, schools.xlsx, ..). All of them reside in the same folder within SharePoint lib. Im asking this as I think there should be a more efficient way to load tables to my data model rather than creating a new connection for each one of the files. Is this even possible? When I googled it, results came back with a zillion of combining results. Maybe answer is silly but Im stuck at the moment

Thanks in adv.  

[chlxco]

What if I duplicate the query the times needed to filter out each one of the files I need? Would that improve performance at the moment of fetching all files? 

[amitchandak · Accepted solution]

@chlxco , As far as I know, as of now, the folder option is to get a table of the same structure and merge those.