Forum Discussion
Stack overflow error when refreshing in service, but not in desktop.
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.
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
ValidationExceptionfrom 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:
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.
2 Replies
- GilbertQ
Super User
Hi Anonymous
Can you confirm you have got the latest version of the on-Premise gateway installed and configured?
- v-angzheng-msft
Community Support
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
ValidationExceptionfrom 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:
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.
