Deploy

APPLIES TO: yesSQL Server 2019 and later Analysis Services yesAzure Analysis Services noPower BI Premium

In this lesson, you configure deployment properties; specifying a server to deploy to and a name for the model. You then deploy the model to the server. After your model is deployed, users can connect to it by using a reporting client application. To learn more, see Deploy to Azure Analysis Services and Tabular model solution deployment.

Estimated time to complete this lesson: 5 minutes

Prerequisites

This article 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.

Important

If deploying to Azure Analysis Services, you must have Administrator permissions on the server.

Important

If you installed the AdventureWorksDW sample database on an on-premises or VM with SQL Server, and you are deploying your model to an Azure Analysis Services server, an On-premises data gateway is required for the process operation to import data from the data source database into the deployed data model.

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, enter the full server name. If connecting to Azure Analysis Services, server name must include the full URL. You can copy an Azure Analysis Services server name from the Overview page in the portal.

    as-lesson13-deploy-property

  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 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 may be prompted to enter your account. Enter your organizational account and password, for example nancy@adventureworks.com. This account must be in Admins on the server.

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

    as-lesson13-deploy-status

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

Important

After deployment is finished, if you created the Azure Synapse Analytics data source using a paid subscription, to prevent unwanted charges to your account, be sure to pause or delete the resource in the portal.

This lesson describes the most common and easiest method to deploy a tabular model from Visual Studio. Advanced deployment options such as the Deployment Wizard or automating with XMLA and AMO provide greater flexibility, consistency, and scheduled deployments. To learn more, see Tabular model solution deployment.

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, if added to a role, can also now connect to the model using a reporting client application such as Microsoft Excel or Power BI.

as-lesson13-ssms

What's next?

Connect with Power BI Desktop
Supplemental Lesson - Dynamic security
Supplemental Lesson - Detail rows
Supplemental Lesson - Ragged hierarchies