Forum Discussion
Incremental refresh and refresh in Analysis services
When refreshing multiple partition you can influence the level of parallelism. May want to tone that down a bit, or even go fully sequential.
Which refresh type did you specify?
Do you have table dependencies (like Auto Date/Time)? - Check the refresh log to see if it processes other tables when you asked for the processing of a particular table.
I did a "full" refresh, and it processed the entire data but refreshed the last 6 months partitions only.
I noticed something very strange. We have a premium embedded capacity with 2 workspaces, one for production and one for developments (excatly same configurations), and I published a semantic model into these 2 workspaces. Now I'm constantly getting memory capacity error for the production workspace, while all refreshes completed successfully in Dev workspace. I checked the workspaces settings and I can't find any differences.
I did some research but did not find anything special.
Thanks.
When refreshing multiple partition you can influence the level of parallelism. May want to tone that down a bit, or even go fully sequential.
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.
Processing Options and Settings (Analysis Services) | Microsoft Learn
Note that I am talking about partitions, not tables.