Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to 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:
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.
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:
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.
Hi @Anonymous
Can you confirm you have got the latest version of the on-Premise gateway installed and configured?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.