SQL Server Analysis Services: Can't choose tabular mode

0
votes

I already tried both, installing a new instance and adding a SQL Server Analysis Service Feature to an existing one. Both possibilities lead to one view:

Choosing between multidimensional/data mining mode and tabular mode not possible

I can't choose tabular mode, no matter what I do. Any suggestions? I'm using SQL Server 2014 but I also tried on a SQL Server 2012 instance, same result.

1
sql-serverssasssas-tabular

1 Answers

4
votes

For SQL Server 2012 and 2014, Tabular mode Analysis Services is only available in Developer, Business Intelligence, and Enterprise editions. If you are using Standard Edition media I would expect that behavior.

In SQL Server 2016 Standard Edition (plus more recent SQL versions), it is possible to install a Tabular mode instance of Analysis Services but it is limited to 16GB of RAM.