Difference 'process default' and 'process full'?

[Anonymous]

What is the difference between ‘Process Default’ and ‘Process Full’?

When I do ‘Process Default’ it works fine, but if I use ‘process full’ I get this error?

Why is this?

[v-jingzhang · Accepted solution]

Hi @Anonymous 

You can refer to this document: Process Database, Table, or Partition (Analysis Services) | Microsoft Docs

Mode	Description
Process Default	Detects the process state of database objects, and performs processing necessary to deliver unprocessed or partially processed objects to a fully processed state. Data for empty tables and partitions is loaded; hierarchies, calculated columns, and relationships are built or rebuilt (recalculated).
Process Full	Processes a database and all the objects that it contains. When Process Full is run for an object that has already been processed, SQL Server Analysis Services drops all data in the object, and then processes the object. This kind of processing is required when a structural change has been made to an object. This option requires the most resources.
Process Clear	Removes all data from database objects.
Process Recalc	Updates and recalculates hierarchies, relationships, and calculated columns.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.