Loading excel files without combining their content.
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