Forum Discussion
Direct Query for today wont refresh overnight
Hi Anonymous,
Could you have tried with the SQL Statement to filter your data before you get your data?
Based on my test, you could use the GETDATE ( ) function (https://docs.microsoft.com/en-us/sql/t-sql/functions/getdate-transact-sql?view=sql-server-2017#b-getting-the-current-system-date) to get today's data.
Regards,
Daniel He
Hi Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Hi Daniel,
Thanks for the help. I've not tried this yet but it looks like it could work. I will let you know when I have tried it.
Hi v-danhe-msft
I have made changes to the Advnaced SQL import as you suggested and added the other filters etc as you can't mix and match it seems. It's running fine for now but we will see if it updates correctly tomorrow. Fingers crossed.