Refresh Never Ends!

[Anonymous]

Hi all,

I have a dashboard that I refresh manually in Desktop as it has some dynamic API calls the service doesn't like. This has worked fine for the last couple of months, but for the past few of days I have been unable to refresh the file - the refresh just hangs there with the usual 'Evaluating...' and  'Waiting for other queries' messages - I have left this for two hours and not a single table loads.

In Power Query a number of my tables have this message displayed:

Information: Evaluation was canceled. If you have disabled the downloading of data previews in the background, this is expected since only one evaluation will be allowed to run at a given time. To see the result of this query, please refresh the preview.

This is perculiar as I haven't changed any preview settings so am unclear why this is being displayed. I've checked the usual root causes of slow refresh like 'Auto date / time' being checked, and I have experimented with enabling and disabling parallel table loads, but to no avail.

Can anyone suggest a fix, or another avenue of investigation. The data for the dashboard is coming from API calls and Google Sheets (where I have already executed the fix to the problem people were having this week).

Thanks,

SamB

[Syndicate_Admin]

Hello, how did you fix the problem. The same thing is happening to me.

[v-stephen-msft]

Hi @Anonymous ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

[v-stephen-msft]

Hi @Anonymous ,

For refreshing takes too much time, there're several solutions for your reference.

1.Reduce unnecessary data from data sources. Pre-integrate data at the data source.

2.It's important to choose the appropriate dataset mode. There are three dataset modes: Import, DirectQuery, and Composite. 

3.Optimize your RLS, DAX and avoid rewriting.

4.Choose Single as much as possible for the direction of the relationship. 

For more information, please kindly refer to:

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

http://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques

https://www.sqlbi.com/topics/optimization/

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , there are two issues logged on Nov 2020. Vote and update, if these are the same as what you are facing. Check for all updates for any solution

https://community.powerbi.com/t5/Issues/SQL-Data-Refresh-Error-in-PowerQuery-PBID-since-Nov-2020-update/idi-p/1516898

https://community.powerbi.com/t5/Issues/PBI-app-slow-data-load/idi-p/1498817

[Anonymous]

Thanks @amitchandak  - neither of those threads are quite what's happening with my file, but thank you for the heads-up 🙂