Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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!
have got any improvements till now?
Hi @jlie,
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?
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.
push
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |