Forum Discussion
haykp
Helper I
3 years agoImporting folder takes very long
Dear Community, Please help to understand why importing folder takes so long and how I can speed up. I have some folder hierarchy which contains neede csv files. The csv files are located bel...
Alex_Sawdo
Resolver II
3 years agoYou could write a script that would combine each of the files into one, thus saving Power Query some processing power for doing all this for you. When pulling data, it's best to try and do all of your data collection/transformations as close to the source as possible and this is an excellent example as to why. If this isn't an option, you'd probably have to stick with multiple queries to break up the processing for a possible performance increase.