Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
49 | |
28 | |
20 | |
20 | |
19 |
User | Count |
---|---|
52 | |
51 | |
26 | |
26 | |
22 |