Evaluating during Data Refresh takes lots of time

[themistoklis]

Hello All,

I have a workspace where i load 12 tables from SQL Server and then i combine them into a new table using PowerQuery.

Also on the combined table I make 2 merges with 2 other tables.

When i press refresh it takes lots of time evaluating the tables and it seems that the evaluating process is delayed on the 'Combined Table' and then it times out.

Is there any way to bypass the evaluating process?

Is there any workaround so as not to get timeout error messages during the refresh?

Thanks

[Icey · Accepted solution]

Hi @themistoklis ,

Hope this post can help you: Microsoft Mashup Evaluation Container is killing my box (PowerBI Desktop = CPU + Memory Hog).

Best Regards,
Icey

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

[themistoklis]

Thank you @Icey 

It partly solved my problem.

I think the latest PowerBI updates might also have an impact to this issue.

[Anonymous]

I think this is a bug. You can try upgrading to a higher version, or downgrade to a lower version to see if it's fixed. 

Another workaround which works for me is to hit "refresh preview" for the stuck query in the power query editor once. 

After this it usually runs fine again.