Forum Discussion
Kletzy
3 years agoAdvocate III
Slow "Evaluating" MySQL - single small table no transformations
We are connecting to a MySQL DB in Azure through a Gateway sitting on a VM (latest version). We are struggling with very slow refreshes which appear to be due to the time taken "Evaluating" these que...
lbendlin
3 years agoSuper User
"Evaluating" means you have modified the meta data sufficiently that Power BI thinks it has to re-fetch it again. Refrain from making frequent design changes. Do not permit Power BI to probe or infer column types.
Subsequent refreshes (after you endured the "Evaluating" phase ) will run faster - until you make the next larger change.
- Kletzy3 years agoAdvocate III
Thanks for your reply lbendlin . Strange thing is there were no changes or transformations at all to the table and only 1 table in a clean model as a test. On Sunday 26 Feb - this issue sudddenly went away and refreshes became super fast (down from 2 hours to around 5 minutes) with no changes on our end so Microsoft definitely fixed the issue on their side.