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.
Just to follow up... Converting the SQL SELECT to a VIEW and then formatting the date column to a date/time ("06/16/22 12:00:00 AM"), solved the issue. Converting to a VIEW fixed the folding error. However, it still wouldn't let me set it up until I change the date to date/time. It would have been helpful if that requirement was in the M$ documentation.
- Tutu_in_YYC
Super User
Thanks for the update!
