Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server Analysis Services
Azure Analysis Services
Fabric/Power BI Premium
The tasks in this article describe how to process a tabular model database, table, or partitions manually by using the Process <object> dialog box in SQL Server Management Studio.
In SQL Server Management Studio, right-click on the database you want to process, and then click Process Database.
In the Process Database dialog box, in the Mode listbox, select one of the following process modes:
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. |
In the Process checkbox column, select the partitions you want to process with the selected mode, and then click Ok.
In SQL Server Management Studio, in the tabular model database which contains the table you want to process, expand the Tables node, then right-click on the table you want to process, and then click Process Table.
In the Process Table dialog box, in the Mode listbox, select one of the following process modes:
Mode | Description |
---|---|
Process Default | Detects the process state of a table object, 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 table object 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 Data | Load data into a table without rebuilding hierarchies or relationships or recalculating calculated columns and measures. |
Process Clear | Removes all data from a table and any table partitions. |
Process Defrag | Defragments the auxiliary table indexes. |
In the table checkbox column, verify the table and optionally select any additional tables you want to process, and then click Ok.
In SQL Server Management Studio, right-click on the table that has the partitions you want to process, and then click Partitions.
In the Partitions dialog box, in Partitions, click the Process button.
In the Process Partition dialog box, 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 (recalculated). |
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, 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. |
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. |
In the Process checkbox column, select the partitions you want to process with the selected mode, and then click Ok.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Configure databases for optimal performance - Training
Configure databases for optimal performance
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
Documentation
Partitions in Analysis Services tabular models
Learn about partitions in Analysis Services tabular models, specifically benefits of partitions and details about partition deployment.
Processing Options and Settings (Analysis Services)
Learn about selecting a processing option to control the type of processing that occurs for each object.
Create and Manage Tabular Model Partitions
Learn how to create and manage partitions for a deployed model.