Automating Tabular Model processing
Power Pivot models in Excel are manually processed only, and Power Pivot models in SharePoint can be scheduled at the data source level. Tabular Models take this one step further by allowing you to process partitions in your model. This allows you to use partitions to keep processing windows short and your model impact low.
Getting ready
In order to work with automation, you should have a deployed version of your Tabular Model to work with. To see how to deploy your model, see the previous recipe on the subject. You should also have a scheduling tool, preferably SQL Server Agent, available to create the job.
How to do it…
- In Microsoft SQL Server Management Studio, open the tabular instance of SQL Server Analysis Services. Right-click on the database you would like to process, and click on the Process Database option on the shortcut menu. In the Process Database dialog, choose the processing mode you would like to use. (I will be using Default for the...
