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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors