Forum Discussion
Expression.Error: Evaluation resulted in a stack overflow and cannot continue.
I am pulling in to queries from Kusto. I have used filters and sorts to pair down the queries within the query editor. These queries are pulling in data from two 4G controllers we have in the field. Once filtered the atributes of the queries are listed below:
Query 1:
6 columns (3 text, 1 numeric, 2 date/time/timezone)
13 rows
Query 2:
8 columns (2 text, 4 numeric, 2 date/time/timezone)
5533 rows
4 of the columns between the two querries match exactly in title and data type. I am attempting to append these queries, but everytime I do it this error results "Expression.Error: Evaluation resulted in a stack overflow and cannot continue." I have tried both direct query and importing the data itself. I have also tried deleting columns to where I am only appending 1 column from each query with the same name and data type. I still recieve this error. I don't think I'm maxing out the number of rows because I have appended millions rows of data before, but I don't know what else could be wrong with it. I have updated my PowerBI and tried opening a new project and trying the same thing in the event there was a glich in the window I had tried it in. No luck. Any ideas on how to append these two queries?
19 Replies
Hi all,
Below is the update for this issue. (IcM: 219724212, 224968762)
This is caused by a common Mashup Engine bug which is currently under investigation. There is no ETA currently. Below are two workarounds to it:
- Workaround #1:
Call Table.AddIndexColumn on each source query before using Table.Combine. Or add a new step to each query using "Index Column" button under Add Column tab before combining tables.
- Workaound #2:
Call Table.Buffer on each of the tables being combined before calling Table.Combine.
Hope this helps.Best Regards,
Community Support Team _ JingThis totally worked for me for SP Lists I addedd Index from 0, thanks a lot
Hi v-jingzhang could you re-explain the work around again , I didn't understand it ?
MAAbdullah_47 You can add a new step to each query using "Index Column" button under Add Column tab before combining tables.
It was the index for me.
Thank you
I am having the same error appending data from Sharepoint Online List and data imported from an excel file.
Hi Anonymous , Can you test if you append a query and its copy (duplicate the query), will they be combined successfully?
Hello v-jingzhang, I duplicated Query 1 and tried to append it with the original Query 1, and still got the error: Expression.Error: Evaluation resulted in a stack overflow and cannot continue.
I tried this by duplicating Query 2, and got the same result.
Please confirm if a fix is in the works for Sharepoint Online and Excel as well. Thank you!
BZ Please try the workarounds in my another reply.
I don't use Table.Combine, but I am wondering if this effects Text.Combine. We have a sample set of data that is less than 700MB but when we try to query the web source recursively the mashup processes use up over 20GB of RAM and then we get the crash error.
This is my line for Text.Combine in my function and in my Query:
Json.Document(Web.Contents("https://datasource:9200", [RelativePath=relativepa, Headers=[#"Authorization"=Text.Combine({"ApiKey ",apiKey,""}), #"Content-Type"="application/json"], Content = Text.ToBinary(urlBody)]))
urlBody = Text.Combine({"{""size"":",batchSize,",""query"":{""match_all"":{}}}"}),
