Deploy From SQL Server Data Tools (SSAS Tabular)
Use the tasks in this topic to deploy a tabular model solution by using the Deploy command in SQL Server Data Tools (SSDT).
Sections in this topic:
Before you deploy your tabular model solution, you must first specify the Deployment Options and Deployment Server properties. For more information about deployment properties and settings, see Tabular Model Solution Deployment (SSAS Tabular).
To configure Deployment Options and Deployment Server properties
In SQL Server Data Tools, in Solution Explorer, right-click the project name, and then click Properties.
In the <project name> Properties dialog, in Deployment Options, specify property settings if different from the default settings.
For models in cached mode, Query Mode is always In-Memory.
You cannot specify Impersonation Settings for models in DirectQuery mode.
In Deployment Server, specify the Server (name), Edition, Database (name), and Cube Name property settings, if different from the default settings, and then click OK.
You can also specify the Default Deployment Server property setting so any new projects you create will automatically be deployed to the specified server. For more information, see Configure Default Data Modeling and Deployment Properties (SSAS Tabular).
To deploy a tabular model solution
In SQL Server Data Tools, on the Build menu, click Deploy <project name>.
The Deploy dialog box will appear and indicate the status of the metadata deployment and the processing (unless Processing Option property is set to Do Not Process) of each table included in the model. After the deployment process is complete, use SQL Server Management Studio to connect to the Analysis Services instance and verify the new model database object has been created or use a client reporting application to connect to the deployed model.