Forum Discussion

huguest's avatar
huguest
Icon for Advocate II rankAdvocate 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 importe...
Need Help
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
    Icon for Advocate II rankAdvocate 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

      • huguest's avatar
        huguest
        Icon for Advocate II rankAdvocate II
        8 years ago

        None of these.  It is a very basic spreadsheet with 2 columns of values an no formula (about 100 rows).