Forum Discussion
Incremental refresh is adding an extra day
This make zero logical sense to me...what am I missing?
Here is what happened today 6/22:
- If the "only refresh complete days" box IS checked the following dates were refreshed:
- 31, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21
- 22 days complete days were refreshed.
- Partitions in May were not consolidated.
- If the "only refresh complete days" box is not checked the following dates were refreshed:
- 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22
- 21 complete days and 1 partial day were refreshed.
- Partitions in May WERE consolidated.
- Interestingly enough they were NOT consolidated when this ran yesterday 6/21.
What this tells me is that even though I've only told Power BI to refresh the last 21 days it is appears to add an extra day to both the exclude today and include today selection. Again that just doesn't make sense based on this but it is what it is.
The times in the images are UTC time. My timezone is Central the premium capacity is in Central.
10 Replies
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?
Hi AxiomaticOne ,
Whether the advice given by lbendlin has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
