Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 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!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
40 | |
27 | |
25 | |
23 | |
21 |
User | Count |
---|---|
56 | |
32 | |
23 | |
22 | |
20 |