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 are some information about my queries and the environment that might help to understand:
What did I already try?
Does anybody has any idea what could cause the problem? Anything is appreciated!
You've tried almost everything I can think of. 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?
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.