Deploy From SQL Server Data Tools (SSAS Tabular)
Applies To: SQL Server 2016
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).
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.
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.
The Deploy dialog box enables you to monitor the progress of a Deploy operation. A deploy operation can also be stopped.
Indicates whether the Deploy operation was successful or not.
Lists the metadata items that were deployed, the status for each metadata item, and provides a message of any issues.
Click to halt the Deploy operation. This option is useful if the Deploy operation is taking too long, or if there are too many errors.