Process Partitions in the Workspace Databse (SSAS Tabular)

APPLIES TO:yesSQL Server Analysis ServicesyesAzure Analysis Services

Partitions divide a table into logical parts. Each partition can then be processed (Refreshed) independent of other partitions. The tasks in this topic describe how to process partitions in the model workspace database by using the Process Partitions dialog box in SQL Server Data Tools (SSDT).

After a model has been deployed to another Analysis Services instance, database administrators can create and manage partitions in the (deployed) model by using SQL Server Management Studio, by script, or by using an IS package. For more information, see Create and Manage Tabular Model Partitions (SSAS Tabular).

To process a partition

  1. In SQL Server Data Tools, click the Model menu, and then click Process (Refresh), and then click Process Partitions.

  2. In the Mode listbox, select one of the following process modes:

    Mode Description
    Process Default Detects the process state of a partition object, and performs processing necessary to deliver unprocessed or partially processed partition objects to a fully processed state. Data for empty tables and partitions is loaded; hierarchies, calculated columns, and relationships are built or rebuilt.
    Process Full Processes a partition object and all the objects that it contains. When Process Full is run for an object that has already been processed, 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.
    Process Data Load data into a partition or a table without rebuilding hierarchies or relationships or recalculating calculated columns and measures.
    Process Clear Removes all data from a partition.
    Process Add Incrementally update partition with new data.
  3. In the Process checkbox column, select the partitions you want to process with the selected mode, and then click Ok.

See Also

Partitions (SSAS Tabular)
Create and Manage Partitions in the Workspace Database (SSAS Tabular)