Lesson 14: Deploy

In this lesson, you will configure deployment properties; specifying a deployment server instance of Analysis Services running in Tabular mode, and a name for the model you deploy. You will then deploy the model to that instance. After it is deployed, users can connect to the model by using a reporting client application. To learn more, see Tabular Model Solution Deployment (SSAS Tabular).

Estimated time to complete this lesson: 5 minutes


This topic is part of a tabular modeling tutorial, which should be completed in order. Before performing the tasks in this lesson, you should have completed the previous lesson: Lesson 13: Analyze in Excel.

Deploy the Model

To configure deployment properties

  1. In SQL Server Data Tools, in Solution Explorer, right-click on the Adventure Works Internet Sales Tabular Model project, and then in the context menu, click Properties.

  2. In the AW Internet Sales Tabular Model Property Pages dialog box, under Deployment Server, in the Server property, type the name of an Analysis Services instance running in Tabular mode. This will be the instance your model will be deployed to.


    You must have Administrator permissions on a remote Analysis Services instance in-order to deploy to it.

  3. Verify the Query Mode property is set to In-Memory.


    The model created by using this tutorial is not supported in DirectQuery mode.

  4. In the Database property, type Adventure Works Internet Sales Model.

  5. In the Cube Name property, type Adventure Works Internet Sales Model.

  6. Verify your selections and then click OK.

To deploy the Adventure Works Internet Sales tabular model

  • In SQL Server Data Tools, click the Build menu, and then click Deploy AW Internet Sales Tabular Model.

    The Deploy dialog box appears and displays the deployment status of the metadata as well as each table included in the model.


Congratulations! You are finished authoring and deploying your first Analysis Services tabular model. This tutorial has helped guide you through completing the most common tasks in creating a tabular model. Now that your Adventure Works Internet Sales Model is deployed, you can use SQL Server Management Studio to manage the model; create process scripts and a backup plan. Users can connect to the model using a reporting client application such as Microsoft Excel or Power View.

Additional Resources

To learn more about tabular model properties that support Power View reports, see https://go.microsoft.com/fwlink/?LinkId=220897.

To see a tutorial about how to configure tabular model reporting properties for Power View, see https://go.microsoft.com/fwlink/?LinkId=219995 .

See Also


DirectQuery Mode (SSAS Tabular)

Configure Default Data Modeling and Deployment Properties (SSAS Tabular)

Tabular Model Databases (SSAS Tabular)