Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
@Anonymous - Well, I would edit the query to track down exactly which step is causing the problem and start there.
The problem is occurs in the Table.Combine step
#"Appended Query" = Table.Combine({Source, Query3}),
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
Thanks for your response, I cannot find a ValidationException in the trace, is there anyway I can upload this so you guys can take a look?
Many thanks
Hi @Anonymous ,
I would recommend you open a support ticket in Power BI support site
https://powerbi.microsoft.com/en-us/support/ since I am unable to reproduce the issue on my side. Thanks for your understanding.
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |