Forum Discussion
Very slow when using data from multiple Excel files from folder
Hello, have just installed latest version of Power BI and am finding Power BI to be extremely slow. As a test, trying to combine data from 5 Excel files with 3 worksheets each (25 columns), max of 6...
It might be the internal storage speed that gets dedicated from AWS to find those local files. This can often be slow. You can try creating a dataflow to do exactly what you do now but from the browser. then use that dataflow as your source in the report. possibly it takes the weight off your local machines shoulders. my tables with 100M rows evaluate in seconds.
Shosher, the files are available locally on the machine. BTW, I saved all worksheets as .csv files and yes, they link readily and I can transform.
BTW, have you tried to link any Excel files or do you normally work with only text/csv files?
