Forum Discussion
Doing Incremental Refresh in Custom Partition
Hello community!
I would like to know if you can help my with this one.
Question 1: I have a necessity to create custom partition (by countries) for a fact table in my dataset. But I would like to implement also de incremental refresh over month with detect change policy. Can someone help?
Question 2: What is the MAttributes in the partition created in the Dataset, can I use them like parametres inside de partition?
I have reading a lot but I can't figure out!
Thank you!
The link I have using are this ones :
Modify an Existing Refresh Policy | Tabular Editor Documentation
Incremental Refresh requires RangeStart and RangeEnd datetime or dateinteger fields. "Country" is neither (unless you are very creative and map each country to a different date)
You can create custom partitions with the Country criteria but you cannot do incremental refresh on them (only selective refresh via XMLA).
Data change tracking also requires a (different) datetime field which seems equally inapplicable in your scenario.
1 Reply
Incremental Refresh requires RangeStart and RangeEnd datetime or dateinteger fields. "Country" is neither (unless you are very creative and map each country to a different date)
You can create custom partitions with the Country criteria but you cannot do incremental refresh on them (only selective refresh via XMLA).
Data change tracking also requires a (different) datetime field which seems equally inapplicable in your scenario.