This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 67%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Hi all, I am a dev in MS and recently I created a Kusto pipeline on ADF, according to design, Kusto will execute at 9 am UTC Time everyday and return some data. However, I found that the scheduled triggered result is always wrong and large than the reality. And when I manually trigger the pipeline, the result is right. I think it has nothing to do with time because I manually trigger the pipeline after 9 am and maybe at afternoon, they both return right result. So it makes me confused. You can reach out me by teams or email in my profile or directly contact me by personal email qsmyhsg@юрий .com. Thanks!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hi @GouKong ,
Welcome to Microsoft Q&A Platform. Thanks for posting the query.
Our team will connect with you to collect necessary data to investigate further.
Looking forward for your response!
Thanks a lot! You can reach out me by zhiqqin@microsoft.com.
Thanks @GouKong for connecting over a call. As discussed, it appears issue with the query as it seems to add duplicates by spanning across overlapping day ranges while pulling the data. Kindly test it in debug mode for 2days consecutively by loading into a new table and let us know if issue is due to trigger/query.
Hi @HarithaMaddi-MSFT ， the bug seems to be finally solved by submit a adf pr to change to a new sink SQL table. Now after several days test, the pipeline works well when it is scheduled triggered. Thanks!
Hi @GouKong ,
Thanks for sharing the update. I converted your comment to an answer as it is beneficial for community members reading the post if you accept the answer.
-----------