| title | description | author | manager | ms.service | ms.topic | ms.date | ms.author | ms.reviewer |
|---|---|---|---|---|---|---|---|---|
Deploy to Azure Analysis Services by using SSDT | Microsoft Docs |
Learn how to deploy a tabular model to an Azure Analysis Services server by using SSDT. |
minewiskan |
kfile |
azure-analysis-services |
conceptual |
10/18/2018 |
owend |
minewiskan |
Once you've created a server in your Azure subscription, you're ready to deploy a tabular model database to it. You can use SQL Server Data Tools (SSDT) to build and deploy a tabular model project you're working on.
To get started, you need:
- Analysis Services server in Azure. To learn more, see Create an Azure Analysis Services server.
- Tabular model project in SSDT or an existing tabular model at the 1200 or higher compatibility level. Never created one? Try the Adventure Works Internet sales tabular modeling tutorial.
- On-premises gateway - If one or more data sources are on-premises in your organization's network, you need to install an On-premises data gateway. The gateway is necessary for your server in the cloud connect to your on-premises data sources to process and refresh data in the model.
Tip
Before you deploy, make sure you can process the data in your tables. In SSDT, click Model > Process > Process All. If processing fails, you cannot successfully deploy.
In Azure portal > server > Overview > Server name, copy the server name.
-
In SSDT > Solution Explorer, right-click the project > Properties. Then in Deployment > Server paste the server name.
-
In Solution Explorer, right-click Properties, then click Deploy. You may be prompted to sign in to Azure.
Deployment status appears in both the Output window and in Deploy.
That's all there is to it!
If deployment fails when deploying metadata, it's likely because SSDT couldn't connect to your server. Make sure you can connect to your server using 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.
Now that you have your tabular model deployed to your server, you're ready to connect to it. You can connect to it with 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.