Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
LuisM2810
Frequent Visitor

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 :

Chris Webb's BI Blog: Custom Queries For “Detect Data Changes” In Power BI Incremental Refresh (cros...

Modify an Existing Refresh Policy | Tabular Editor Documentation

Configure Incremental Refresh with Tabular Editor - YouTube

 [MS-SSAS-T]: Partition Object | Microsoft Learn (46)

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.