cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors