Forum Discussion
Incremental refresh not pulling today's data
Hi, I've configured an incremental refresh out of a SQL database. It is configured to pull data greater than RangeStart and less of equal to RangeEnd, the incremental settings are keep 2 years of data and refresh in the last one day based on insert DT. This is set up for 2 tables, the original one pulling from SQL and one more which references the source. The refresh finish successfully, but it brings data up to yesterday only.
I have another report with same configuration and it works just fine, what could I be missing? This one is configured on a single table though
3 Replies
Update: It is definitely something with the 2nd table referencing the source, I've disabled the incremenetal refresh on it and it is now pulling today's data... can't find a way to fix this =(
Update 2: It works the first time, the one that runs right after the report is published, then the schedule refresh won't load anything, it's been 2 days and my report stayed at Sep 24 even when it ran today
