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).

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI huguest,

         

        I'd like to suggest you to turn off load option of queries to confirm which query caused the stuck issue.

         

        Regards,

        Xiaoxin