Deploy a model from Visual Studio

Once you've created a server in your Azure subscription, you're ready to deploy a tabular model database to it. You can use Visual Studio with Analysis Services projects to build and deploy a tabular model project you're working on.

Prerequisites

To get started, you need:

Tip

Before you deploy, make sure you can process the data in your tables. In Visual Studio, click Model > Process > Process All. If processing fails, you can't successfully deploy.

Get the server name

In Azure portal > server > Overview > Server name, copy the server name.

Screenshot showing how to get server name in Azure.

To deploy from Visual Studio

  1. In Visual Studio > Solution Explorer, right-click the project > Properties. Then in Deployment > Server paste the server name.

    Screenshot showing how to paste server name into deployment server property.

  2. In Solution Explorer, right-click Properties, then click Deploy. You may be prompted to sign in to Azure.

    Screenshot showing Deploy to server.

    Deployment status appears in both the Output window and in Deploy.

    Screenshot showing deployment status.

That's all there is to it!

Troubleshooting

If deployment fails when deploying metadata, it's likely because Visual Studio couldn't connect to your server. Make sure you can connect to your server using SQL Server Management Studio (SSMS). Then make sure the Deployment Server property for the project is correct.

If deployment fails on a table, it's likely because your server couldn't connect to a data source. If your data source is on-premises in your organization's network, be sure to install an On-premises data gateway.

Next steps

Now that you have your tabular model deployed to your server, you're ready to connect to it. You can connect to it with SQL Server Management Studio (SSMS) to manage it. And, you can connect to it using a client tool like Power BI, Power BI Desktop, or Excel, and start creating reports.

To learn about advanced deployment methods, see Tabular model solution deployment.