Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 58 | |
| 56 | |
| 35 | |
| 18 | |
| 14 |