Getting all files as separated quieries

Hi Islam 

The general idea with Power Query is to combine data into a single table.  What you are trying to do is combine 100 files into a single query (table) but then split them again into 100 tables in your Data Model.  Do you really need each file as a separate table in the model?  It doesn't sound like thr gith approach if the data is related as I'd expect it to be.

You could create a query that has as it's final result a column that consists of 100 rows with each row being a table.  But you would then have to create 100 queries to access the table in each row.

Regards

Phil