Forum Discussion
Power BI Desktop Refresh Slow
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
