Forum Discussion
Power BI Desktop Refresh Slow
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.
jillian Well that only explains the reason, not the cause. We'll investigate this internally.
I'm guessing your data probably have many columns of date/time type, so behind the scenes we are trying to create a date table automatically, which takes time. Disabling the auto date/time feature means you'll probably need to manually create a date table in the model. There are many ways to do this, and many posts about it on this forum.
Regards,
PQ
Hi there, I've tried all the things mentioned in this post and my refresh still takes around half an hour (used to take around 15 seconds). Running latest version of Power BI Desktop. Any ideas?
