Incremental Refresh Questions

[Xxx_Userpwbi]

Hello, community,

I have a question about applying incremental updates. When we apply the update and select the monthly period, the range is set from 11/01 to 11/30.

If I select the period in days, it will update the data from the last 31 days.

I would like to understand why this occurs and which option I should choose.

[lbendlin]

how many rows would you have in the monthly partition? How many in the quarterly and yearly?

Ultimately the question is - can you successfully refresh a particular partition within the 5 hour hard limit?  If you can't then select the next lower granularity that can do it.

"Specify the largest partition size you can get away with"

[Xxx_Userpwbi]

hi @lbendlin, 

i'am Maintaining 2 years of information. My semantic model updates once per day, and the update occurs after the fact tables’ jobs are completed. For performance optimization, would it be better to select 2 months instead of 30 days?

Monthly Partition:

 433,333 rows.

Quarterly Partition:

Approximately 1.3 million rows per quarter.

Annual Partition:

About 5.2 million rows per year.

[lbendlin · Accepted solution]

yes, those are tiny partitions. Select 2 months.