topic Incremental refresh not pulling today's data in Report Server

Incremental refresh not pulling today's data

oscarmqz — Tue, 24 Sep 2019 18:50:49 GMT

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

Re: Incremental refresh not pulling today's data

oscarmqz — Tue, 24 Sep 2019 22:57:45 GMT

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 =(

Re: Incremental refresh not pulling today's data

oscarmqz — Thu, 26 Sep 2019 18:25:13 GMT

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

Re: Incremental refresh not pulling today's data

Anonymous — Tue, 28 Apr 2020 15:25:09 GMT

did you manage to get this working? I myself am having the same problem