Forum Discussion
Power BI Desktop Refresh Slow
Power BI Desktop just "hangs" with spinning icons for ~5mins while refreshing. Here is a screenshot showing the load. The mouse and other applications still work fine but the Power BI desktop application is frozen waiting. It's doing this across multiple .pbix files and even on ones with a very small dataset. It started happening after this latest version from yesterday evening.
I've tried re-installing the application and a clean reboot and still seeing this behavior.
-jillian
jillian are the numbers for any of these queries moving?
If you go to the Task Manager, how many Microsoft.Mashup.Container*.exe can you find there, and are any of them busy?
Have you tried to disable relationship detection in the settings dialog?
The data changes once per hour for this particular dataset. The entire .pbix is only 3.8MB including the data. I'm currently seeing 3x Microsoft.Mashup.Container.NetFX40.exe's running.
I tried disabling both Import / Autodetect Relationships as well as disabling Type Detection. I'm seeing the same slowness on this latest build.
-jillian
jillian, one other thing to turn off (just to diagnose) in the settings dialog:
Current File->Data Load->Auto Date/Time
With this off, try refresh again
I disabled Data Load -> Auto Date/Time and voila! That fixed it!
Thank you. Wonder what changed in the latest build that's causing this. I havent ran into this problem before.