Forum Discussion

huguest's avatar
huguest
Advocate II
8 years ago

Report Refresh getting "stuck"

Hello,

I am trying to refresh my report in Power BI Desktop and after loading data for awhile, it appears to get stuck.

 

The table contains data from a combination of queries that are all imported into the model.  It previews fine in the Query Editor.  After loading data from several of the queries (Excel, Oracle, SQL), the refresh window shows that it is at "183 KB from Spreadsheet.xlsx" and stays there (it has been several hours).  It used to refresh just fine, I made a few edits (but not to that spreadsheet), and now it is no longer working.

 

I recreated that spreadsheet from scratch in case the file might have been broken, but no difference.

 

Any idea what might be happenign?

 

Thank you :)

 

 

Need Help

12 Replies

  • Data-Bit's avatar
    Data-Bit
    Advocate I
    5 years ago

    I have encountered this issue multiple times in different companies I have worked and it's a pain... sometimes i have to rebuild or download a copy from the server again and pray.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi huguest,

     

    It sounds like you have reference other queries in query editor, it may caused stuck loading.(the referenced query not finish loading, current query are wait for reference query finish load)

     

    If this is a case, I'd like to suggest you turn on the 'Parallel loading' in options menu.

     

    Regards,

    Xiaoxin Sheng

    • huguest's avatar
      huguest
      Advocate II
      8 years ago

      Hello Xiaoxin Sheng, thank you for your suggestion but that feature was already activated in my report. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI huguest,

         

        Is there any connection to external datasource in your excel file? Or your use link table function to import excel workbooks?

         

        Regards,

        Xiaoxin Sheng

  • Crazyel's avatar
    Crazyel
    Regular Visitor
    6 years ago

    I get the same issue, stuck refreshing its been over an hour, and its is a fairly small spreadsheet. I believe it has to do with older excel spreadsheets and older PBI desktop versions. I opened a new Excel copy and pasted values  and column header and used a new excel file with pasted values information.

     

    Good Luck 

    • eromrab's avatar
      eromrab
      Frequent Visitor
      6 years ago

      I've just gotten in the habit of hitting refresh, then cancel on the pop up, then refresh again. It works every time. I'm here because I was trying to find out a way to fix it, but looks like no one else has figured it out either :-(

  • jdj's avatar
    jdj
    Frequent Visitor
    5 years ago

    Anyone with a solution yet? Got the same issue (both with Power Query in Excel and in Power BI) and also just gotten in the habit of hitting refresh, then cancel on the pop up, then refresh again. But that's not really a solution... ðŸ¤”