Report Refresh getting "stuck"

[huguest]

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 🙂

[Data-Bit]

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.

[jdj]

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

[jdj]

Found something that seems to work: https://community.powerbi.com/t5/Power-Query/Long-time-quot-Evaluating-quot-for-no-apparent-reason-d... 

[Crazyel]

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]

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 😞

[v-shex-msft]

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]

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

[v-shex-msft]

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]

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

[v-shex-msft]

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

[Anonymous]

I'm having the same issue. Did you find a solution?

[huguest]

Unfortunately not really.  Sometimes I feel like it is the report itself, sometimes I feel like it is something else (connection or other).  I tried to simplify my report as much as possible (eliminating uncessary transformations, combining some steps, etc.) and it is much better but I am still running into the same issue at times.

Good luck!