Forum Discussion
Islam
Helper V
Helper VGetting all files as separated quieries
Hello everyone ok experts 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- g...
PhilipTreacy
Super User
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
IslamHelper V
Helper Vyou mean that i create subfolder for each excel file as to be the only way to get each spreadsheet as a separated query ?