Process Data (SSAS Tabular)

When you import data into a tabular model, in Cached mode, you are capturing a snapshot of that data at the time of import. In some cases, that data may never change and it does not need to be updated in the model. However, it is more likely that the data you are importing from changes regularly, and in order for your model to reflect the most recent data from the data sources, it is necessary to process (refresh) the data and re-calculate calculated data. To update the data in your model, you perform a process action on all tables, on an individual table, by a partition, or by a data source connection.

When authoring your model project, process actions must be initiated manually in SQL Server Data Tools (SSDT). After a model has been deployed, process operations can be performed by using SQL Server Management Studio or scheduled by using a script. Tasks described here all pertain to process actions that you can do during model authoring in SQL Server Data Tools (SSDT). For more information about process actions for a deployed model, see Process Database, Table, or Partition.

Related Tasks