Forum Discussion
Stack Overflow Error Appending
After trying to append two queries together I receive the stack overflow error, the data isn't too large and I've actually performed the same sequence with other very similar data from Azure. I cannot share the data as it is confidential, however please see below the queries:
let
Source = AzureDataExplorer.Contents("yyyyyyyyyyyyyyyyyyyyy", "xxxxxxxxxx", " let stime = datetime(2020-07-16 00:00:00);#(lf) let etime = datetime(2020-07-16 23:00:00);#(lf) Common2#(lf) | where SiteId ==('yyyy')#(lf) | where TS between (stime..etime)#(lf) | where Tag == 'xxxxxxxxxx'#(lf) |sort by TS asc#(lf) |serialize TS#(lf) |extend Value = tolong(Value)#(lf) |extend newsession=iff(isnull(prev(Value)) or ((Value) <= 250 and prev(Value) > 250), 1, 0)#(lf) |extend session_id = row_cumsum(newsession) ", [MaxRows=null, MaxSize=null, NoTruncate=null, AdditionalSetStatements=null]),
#"Appended Query" = Table.Combine({Source, Query3}),
#"Added Conditional Column" = Table.AddColumn(#"Appended Query", "Main Mixer Weight", each if [Tag] = "yyyyyyyyyyyyyyyyyyyyy" then [Value] else null),
#"Changed Type1" = Table.TransformColumnTypes(#"Added Conditional Column",{{"Main Mixer Weight", type number}}),
#"Changed Type" = Table.TransformColumnTypes(#"Changed Type1",{{"TS", type datetime}})
in
#"Changed Type"
and I am a query with several more columns to it with the same date and time.
I have done this same query with more data from a similar source and have no problems with it, could anyone help?
5 Replies
- Greg_DecklerCommunity Champion
Anonymous - Well, I would edit the query to track down exactly which step is causing the problem and start there.
- AnonymousNot applicable
The problem is occurs in the Table.Combine step
#"Appended Query" = Table.Combine({Source, Query3}),- v-deddai1-msftCommunity Support
Hi Anonymous ,
I really can't reproduce your issue. Just follow the steps in : https://superuser.com/questions/1193926/stack-overflow-error-importing-data-to-microsoft-power-bi-evaluation-resulted to get actual error message.
Please report this as an Issue using issues.powerbi.com. first check to see if it has already been reported.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai