Lesson 13: Deploy
Applies to: SQL Server 2016 and later Analysis Services Azure Analysis Services Power BI Premium
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
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
In Solution Explorer, right-click the AW Internet Sales project, and then click Properties.
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.
You must have Administrator permissions on the remote Analysis Services instance in-order to deploy to it.
In the Database property, type Adventure Works Internet Sales.
In the Model Name property, type Adventure Works Internet Sales Model.
Verify your selections and then click OK.
To deploy the Adventure Works Internet Sales tabular model
In Solution Explorer, right-click the AW Internet Sales project > Build.
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 firstname.lastname@example.org. 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.
When deployment successfully completes, go ahead and click Close.
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.