Forum Discussion
Error while accessing table ... because it contains overflow errors
I have this error in a Power Query that has worked well for months, and that loads data from an Excel table (which gets its data from a SQL Connection).
How do I find where the error is exactly? I can't see anything wrong with the table itself. What steps can I take to solve this problem?
(Sorry, can't join the file, company data. The table in question is app. 15Mb, 21000 rows, columns A-CX).
You may try to play with Diagnostics as here twinfield - Stack overflow error importing data to Microsoft Power BI: 'Evaluation resulted in a stack overflow and cannot continue.' - Super User (that's for Power BI Desktop, but in Excel that's practically the same).
Since you work with Excel table, you may query it by portions and narrow the range with error. Check dates fields, overflow error appears if in it number more than 31 Dec 9999 in equivalent.
4 Replies
You may try to play with Diagnostics as here twinfield - Stack overflow error importing data to Microsoft Power BI: 'Evaluation resulted in a stack overflow and cannot continue.' - Super User (that's for Power BI Desktop, but in Excel that's practically the same).
Since you work with Excel table, you may query it by portions and narrow the range with error. Check dates fields, overflow error appears if in it number more than 31 Dec 9999 in equivalent.
SergeiBaklan Great, thanks!
I caught the error, meanwhile, with a more "brute" approach by deleting half of the columns, checking if the error persisted, if yes than delete the next half, if not check the other half, etc. I narrowed it down to 4 rows in 1 column that way. (Maybe useful for future reference if someone has the same problem).
But your link may prove useful in the future, thanks.
Thank you for the update. And what the reason of the error, if that's not a secret?
