Forum Discussion
amir_mm
2 years agoHelper III
Incremental refresh and refresh in Analysis services
Hello, I have defined an incremental refresh policy to refresh the last 6 months and archive the entire data (5 years) to reduce peak memory usage during a refresh. But, I don't see much difference ...
- 2 years ago
When refreshing multiple partition you can influence the level of parallelism. May want to tone that down a bit, or even go fully sequential.
lbendlin
2 years agoSuper User
When refreshing multiple partition you can influence the level of parallelism. May want to tone that down a bit, or even go fully sequential.
amir_mm
2 years agoHelper III
Thank you! May I know how I can do it fully sequential? As I know, we can change the maximum parallel loading in PBI desktop, but not sure about the full sequential method.
- lbendlin2 years agoSuper User
Processing Options and Settings (Analysis Services) | Microsoft Learn
Note that I am talking about partitions, not tables.