Forum Discussion
Post Prodigyincremental refresh not working - still refreshing whole data set - am I missing something?
Super Userit is normal that the Source step Native Query is greyed out. In fact, you don't really need Query Folding for incremental refresh. It is preferred but not required.
The only surefire way to check if incremental refresh is working is to look at the partitions and their last processed dates.
Post Prodigylbendlin Where do you view the partitions? Do you need premium capacity for that?
When I set up incremental refresh for the table, I set the option "store rows where column "OrderDate" is in the last:" to 30 days. And I selected the option to detect data changes. However when I publish to bi service the dates are from the beginning of the year 1/1/2020 to the current date. Why is it not only for 30 days as I have specified?
tylesftwHelper II
Hey mate, did you find the answer to this?? Have the exact same problem