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
Configure Incremental Refresh with Tabular Editor - YouTube
[MS-SSAS-T]: Partition Object | Microsoft Learn (46)
Solved! Go to Solution.
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.
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.