Forum Discussion
Incremental Refresh Questions
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.
yes, those are tiny partitions. Select 2 months.
3 Replies
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"
- 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.
yes, those are tiny partitions. Select 2 months.
