Forum Discussion
Incremental refresh is adding an extra day
the premium capacity is in Central.Doesn't matter, the partition management is based on UTC.
Respectfully this isn't a helpful comment and is distracting to anyone looking at this issue. This dissuades people from providing information about their environment upfront if they are only going to be told what isn't relevant to the issue being presented. I hadn't said it was the sole issue.
Did you figure out what caused the extra day?
Regretfully no, I have it on the backlog to go back and do detailed testing on smaller incremental refresh periods and create multiple tables with different settings.
As a work around we've just added +1 day to the expected range so that we can hit the partitions with an API refresh monthly to true up historical data.Just to confirm - you made RangeStart inclusive and RangeEnd exclusive?