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.
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 queries (at least on the desktop version). The time has more than doubled since the latest Micrsoft updates.
We have tested on a single table in a clean file with 14 rows and 7 columns and zero steps apart from the source and navigation - a very simple clean table with no transformations - and the "Evaluating" still takes 1-2 minutes.
Are there any thoughts or suggestions to resolve this?
"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.
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.
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.