Stack overflow error when refreshing in service, but not in desktop.

[Anonymous]

This is the error message I recieve - 

Evaluation resulted in a stack overflow and cannot continue.;Evaluation resulted in a stack overflow and cannot continue. Evaluation resulted in a stack overflow and cannot continue. Evaluation resulted in a stack overflow and cannot continue.. The exception was raised by the IDbCommand interface. Table: Plant

It has refreshed perfectly fine in the past this issue seems to have randomly popped up. Also, It gives a completely different table every time it is refreshed. I would appreciate any help with this.

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

According to some other experience, this may be a bug with Power BI not parsing the exceptions well.

You may find the actual error message by performing the following steps:

1. From the Query Editor dialog or the main screen, go to File > Options and settings > Options.

2. Go to Diagnostics and check Enable tracing. Click on Open traces folder. Dismiss the dialog by click on OK.

3. Explorer opens with a path similar to C:\Users\Me\AppData\Local\Microsoft\Power BI Desktop\Traces. Go back to Power BI and click on Refresh in the ribbon.

4. Power BI generates several log files in the folder previously opened. Open the file starting with Microsoft.Mashup.Container.NetFX40. This is the log file containing the actual error messages.

5. Find the latest error message. Usually you can find that by searching for ValidationException from bottom to top.

Sample:

itgeneor028: Unknown table projjects ( Possible alternatives: (Projects, ProjectWBS)
   at Invantive.Data.ValidationException..ctor(String messageCode, String messageText, String kindRequest, String localStackTrace, String nk, Exception innerException)

refer:

Stack overflow error importing data to Microsoft Power BI: 'Evaluation resulted in a stack overflow and cannot continue.'

Get more information from the link below

Microsoft Excel Power Query Expression Error (overflow error)

Expression.Error: Evaluation resulted in a stack overflow and cannot continue.

Expression.Error: Evaluation resulted in a stack overflow and cannot continue

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

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

[GilbertQ]

Hi @Anonymous 

Can you confirm you have got the latest version of the on-Premise gateway installed and configured?