Lesson 13: Deploy

APPLIES TO:yesSQL Server Analysis Services (starting with 2016)yesAzure Analysis Services

In this lesson, you will configure deployment properties; specifying an on-premises or Azure server instance, and a name for the model. You'll then deploy the model to that instance. After your model is deployed, users can connect to it by using a reporting client application. To learn more about deploying, see Tabular model solution deployment and Deploy to Azure Analysis Services.

Estimated time to complete this lesson: 5 minutes

Prerequisites

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 12: Analyze in Excel.

Deploy the model

To configure deployment properties

  1. In Solution Explorer, right-click the AW Internet Sales project, and then click Properties.

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

    aas-deploy-deployment-server-property

    Important

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

  3. In the Database property, type Adventure Works Internet Sales.

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

  5. Verify your selections and then click OK.

To deploy the Adventure Works Internet Sales tabular model

  1. In Solution Explorer, right-click the AW Internet Sales project > Build.

  2. Right-click the AW Internet Sales project > Deploy.

    When deploying to Azure Analysis Services, you'll likely be prompted to enter your account. Enter your organizational account and passsword, for example nancy@adventureworks.com. This account must be in Admins on the server instance.

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

    aas-deploy-status

  3. When deployment successfully completes, go ahead and click Close.

Conclusion

Congratulations! You're 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 also now connect to the model using a reporting client application such as Microsoft Excel or Power BI.

as-tabular-lesson13-ssms

See also

DirectQuery Mode (SSAS Tabular)
Configure Default Data Modeling and Deployment Properties (SSAS Tabular)
Tabular Model Databases (SSAS Tabular)

What's next?