Forum Discussion
Solved
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 per...
yes, those are tiny partitions. Select 2 months.
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.