Forum Discussion
Helper VGetting all files as separated quieries
Super UserHi Islam
You'll have to put all the files in the same folder and then use the Get from Folder connector to load all files in the same query.
If the files are spread around in different folders, they will load as different queries, 1 query per file. Unless you write code that specifically reads a list of the paths and loads one by one. This might be more work than is necessary when compared to moving all files into the same folder?
regards
Phil
Helper Vok sir let me clear out what i need exactly
let's assume this example
if i have a folder containing over 100 different type files
what i wanna do using power query is :-
1- get the folder path automtically no matter where folder is or to make it simple i wanna make it as a parameter and i\ll just change it on changing folder location
2- i wanna filter folder files to show only excel spreadsheets
3- finally i wanna add each table in each of excel files in step 2 to data model as a separated query table\
i can make the first 2 steps but for the third and final step i have no idea