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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors