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 from the table(s) and then just hangs for about 5-10 minutes. (Even for a small data set like 1000 rows.) After some time the application will then complete the refresh.

 

Anyone know whats going on here?

 

-jillian

  • 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

14 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I too am having a slow refresh after doing the latest update in Aug - I see no one from Microsoft has responded to this post lately.  Please respond with insight.

     

    Thanks!!

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I have also same problems, disabled auto detect relationships and auto date/time but no luck. Hangs in Waiting for other quories and Evaluating.

       

      This is very frustrating.

  • pqian's avatar
    pqian
    Microsoft Employee
    10 years ago

    jillian can you elaborate what "hangs for 5-10 mins" mean? Is it responsive to mouse input (like dragging), is there a status dialog displaying what it is doing? Can you take a screenshot of the hang?

    • jillian's avatar
      jillian
      Advocate II
      10 years ago

      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

      • pqian's avatar
        pqian
        Microsoft Employee
        10 years ago

        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?

  • sdkearns's avatar
    sdkearns
    Frequent Visitor
    9 years ago

    I am also experiencing slow refresh times against Oracle data.  I am on version 2.49.4831.521 64-bit (August, 2017)  Please  help.