Forum Discussion
Power Query Very Slow using get files from folder
I have a Master file that uses power query to import all xlsx files from a folder. Pretty simple setup, since all the files are setup (have the same headers 55 columns) and formatted the same way. Cu...
- XLSX files are slower to read than (i.e.) CSV files due to the complexity of the file structure
- Sheets are generaly slower to read than Tables
- If you rely on the From Folder wizard that initially creates Helper Queries you can expect slightly better performances (not much due to #1) if you write your own code
- See Speed/Performance aspects from ImkeF, there are probably a few things for you...
- Just in case also have a look to Excel.Workbook() And The delayTypes Option from ChrisWebb
