Forum Discussion

Milejdi8's avatar
Milejdi8
Frequent Visitor
2 years ago

Incremental refresh messing up with query calculation

Hi all,    struggling with Incremental refresh behavior again...  Part of the query that acts weirdly:        #"GroupedData" = Table.Group(#"Removed Columns", {"customer", "fiscper"},         {...
Need Help
Milejdi8's avatar
Milejdi8
Frequent Visitor
2 years ago

Can you clarify this "Partition Date" column? How do you direct incremental refresh to base the partition on dates in that column and not on the other date column?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Let's say our fiscal year goes from September to August.  I want to refresh partitions by fiscal year. So I introduce a Partition Date that is shifted four months, so that the "2023"  partition now actually contains data for FY2023 rather than calendar year 2023.

 

There is an interesting side effect to this - Standard Incremental Refresh can't handle future dates. You need to use XMLA for that, but you are already using it anyway when you are manually refreshing partitions.