Change SQL Server Analysis Services Deployment Mode from Multidimensional to Tabular

I recently installed SQL Server Analysis Services (SSAS) and used the default settings during the installation. Unfortunately, this meant I installed it using a Deployment Mode of Multidimensional instead of Tabular.

I wanted to avoid uninstalling so I did some poking around and found there is a setting file which can be amended to change the Deployment Mode. The file is msmdsrv.ini which is in C:\Program Files\Microsoft SQL Server\MSAS15.GP\OLAP\Config if you have installed it into the default location:

Find the DeploymentMode node and change the number to 2:

The available options for this setting are:

0. Multidimensional
1. SharePoint
2. Tabular

Once you’ve saved the changes, restart the SSAS service and it will be running in the deployment mode.

Read original post Change SQL Server Analysis Services Deployment Mode from Multidimensional to Tabular at azurecurve|Ramblings of an IT Professional