Deploy From SQL Server Data Tools (SSAS Tabular)

  • Article

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:

  • Configure Deployment Options and Deployment Server properties

  • Deploy a Tabular Model Solution

  • Deploy Status

Configure Deployment Options and Deployment Server Properties

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

  1. In SQL Server Data Tools, in Solution Explorer, right-click the project name, and then click Properties.

  2. In the <project name> Properties dialog, in Deployment Options, specify property settings if different from the default settings.

    Note

    For models in cached mode, Query Mode is always In-Memory.

    Note

    You cannot specify Impersonation Settings for models in DirectQuery mode.

  3. 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.

Note

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).

Deploy a Tabular Model Solution

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.

Deploy Status

The Deploy dialog box enables you to monitor the progress of a Deploy operation. A deploy operation can also be stopped.

  • Status
    Indicates whether the Deploy operation was successful or not.

  • Details
    Lists the metadata items that were deployed, the status for each metadata item, and provides a message of any issues.

  • Stop Deploy
    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.

See Also

Concepts

Tabular Model Solution Deployment (SSAS Tabular)

Configure Default Data Modeling and Deployment Properties (SSAS Tabular)

Power View (SSRS)