Forum Discussion
Incremental refresh is loading data only within the parameters date range after refresh in service
Hi,
I am going crazy with this incremental refresh. It's just not happening. The data is refreshing, without any error but not giving the entire date range's data. The steps I have followed are
1. In all the fact tables, applied the Date Paramater filter on the step where Query Folding is happening. Post that there are other steps, like changing column names, merging with other tables, etc.
2. All the fact tables are appeneded in one table to create a separate Compiled sales table.
3. There are other dimension tables on which I have not added the incremental refresh.
4. All these tables are loaded.
5. On each individual sales table, incremental refresh is then applied.
I want to load data from last year and all the databases have this data. RangeStart Date is 1st Jan23 and RangeEnd Date is 31st May 23. After publishing and after the 1st manual refresh, data for 1st Jan - 31stMay is only reflecting.
Please help.
Thanks & Regards,
Neha