Forum Discussion

jillian's avatar
jillian
Advocate II
10 years ago
Solved

Power BI Desktop Refresh Slow

I just upgraded to the latest Power BI Desktop Version: 2.32.4307.522 64-bit (February 2016).   Since the upgrade, when i attempt to Refresh the data from SQL Server, the application loads the rows...
  • pqian's avatar
    pqian
    10 years ago

    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

pqian's avatar
pqian
Microsoft Employee
10 years ago

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

jbee's avatar
jbee
Regular Visitor
9 years ago

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?

  • dmoffat's avatar
    dmoffat
    Advocate II
    9 years ago

    Me too ... What's up here?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I started noticing the slow refresh issue with upgrading to the latest Power BI Desktop version (2.48.4792.721 64-bit (July 2017). 

  • jbee's avatar
    jbee
    Regular Visitor
    8 years ago

    I tracked mine down to the refresh from OneDrive for Business - used to work fine when I had not much in OneDrive for Business, but now that I have tens of thousands of files, the refresh takes over half an hour. Query filters to correct folder and filetype.

     

    Worked it out by looking at the refresh size which showed hundreds of MB, but the folder contains no more than 100KB of data.

     

    Can anyone assist with this?

     

    Cheers