Forum Discussion
Direct Query for today wont refresh overnight
Hi, I have a report which is built on a Direct Query to an SQL server. This brings in real time data for today only. I have the following filter in place: ...
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 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.