Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Anonymous
Not applicable

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.

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
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 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.

View solution in original post

2 REPLIES 2
v-angzheng-msft
Community Support
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 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
Super User
Super User

Hi @Anonymous 

 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors