Forum Discussion
Solved
Incremental Refresh - Not retaining old records
I have a SQL query that pulls data from a table that has 30 days of records. I want to set up Incremental Refresh to pull the new records and keep the old records for up to a year. From what...
I had to convert the date field to a date/time. It now looks like this "06/16/22 12:00:00 AM". I changed the parameters to match the date/time format and now it lets me set up the incremental update without the folding error. I will be testing it this evening when the new data comes in and will report back.
I had to convert the date field to a date/time. It now looks like this "06/16/22 12:00:00 AM". I changed the parameters to match the date/time format and now it lets me set up the incremental update without the folding error. I will be testing it this evening when the new data comes in and will report back.
Tutu_in_YYC
Super User
Super UserLets hope it works!