Deploy solutions by using the Deployment Wizard

Applies to: SQL Server Analysis Services Azure Analysis Services Power BI Premium

The Analysis Services Deployment Wizard uses JSON output files generated from an Analysis Services project as input files. These input files are easily modifiable to customize the deployment of an Analysis Services project. The generated deployment script can then either be immediately run or saved for later deployment.


The Analysis Services Deployment Wizard/Utility is installed with SQL Server Managment Studio (SSMS). Be sure you're using the latest version. If running from the command prompt, by default, the latest version of the deployment wizard is installed to C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio.

You can deploy by using the wizard as described here. You can also automate deployment or use the Synchronize capability. If the deployed database is large, consider using partitions on target systems. You can automate partition creation and population by using Tabular Object Model (TOM), Tabular Model Scriting Language (TMSL), and Analysis Management Objects (AMO).


Neither the output files nor the deployment script will contain the user id or password if these are specified in either the connection string for a data source or for impersonation purposes. Since these are required for processing purposes in this scenario, you will add this information manually. If the deployment will not include processing, you can add this connection and impersonation information as needed after deployment. If the deployment will include processing, you can either add this information within the wizard or in the deployment script after it is saved.

In this section

The following articles describe how to work with the Analysis Services Deployment Wizard, the input files, and the deployment script:

Article Description
Running the Analysis Services Deployment Wizard Describes the various ways in which you can run the Analysis Services Deployment Wizard.
Understanding the input files Used to create the deployment Script Describes which files the Analysis Services Deployment Wizard uses as input values, what each of those files contains, and provides links to topics that describe how to modify the values in each of the input files.
Understanding the Analysis Services deployment script Describes what the deployment script contains and how the script runs.

See also

Deploy model solutions by using XMLA
Synchronize Analysis Services databases
Understanding the input files used to create the deployment script
Deploy model solutions with the Deployment Utility