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: