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 https://www.thebiccountant.com/speedperformance-aspects/ from ImkeF, there are probably a few things for you...
- Just in case also have a look to https://blog.crossjoin.co.uk/2019/02/02/excel-workbook-and-the-delaytypes-option-in-power-query-power-bi/ from ChrisWebb