Forum Discussion
Very long refresh-/loading-times with MySQL database
Hey, PowerBI seems to be getting very slow when updating/refreshing data from our MySQL Server. When I hit the refresh, PowerBI is taking ages (several minutes!) in "Evaluating..." step. Here...
Hi jlie,
You've tried almost everything I can think of.:smileylol: Just one more check, could there be too much columns in your tables? If that is case, could you try removing the unused fields/columns to see if it helps? And have you tried importing the same data with Excel to see how long it takes for refresh?
Regards
Hey v-ljerr-msft, unfortunately, the columns can not be the problem's cause. I already tested it with just one single ID column and had no improvement in "Evaluating" at all.
Importing the data from files is not exactly possible, since my original queries have some advanced stuff like joins, complex filters, etc. However, importing CSV/Excels in general works flawlessly, so I guess that would not help me either.