SSAS Tabular Mode in SQL Server 2016 Standard

[alexanderg]

Hi Everyone!

In SQL Server 2016 Standard is it possible to implement SSAS models in tabular mode? If so .. what disadvantages or considerations would have to be dealing with the Standard version and not the Enterprise. I am planning to deploy a Power BI Solution having a SSAS Tabular Model as a Back End.

Regards

[v-shex-msft · Accepted solution]

HI @alexanderg,

Based on document, it is possible to implement SSAS models in tabular mode, please refer to below link to know more about this:

Analysis Services Features Supported by the Editions of SQL Server 2016

Tabular models

Feature	Enterprise	Standard	Web	Express with Advanced Services	Express with Tools	Express	Developer
Hierarchies	Yes	Yes					Yes
KPIs	Yes	Yes					Yes
Perspectives	Yes						Yes
Translations	Yes	Yes					Yes
DAX calculations, DAX queries, MDX queries	Yes	Yes					Yes
Row-level security	Yes	Yes					Yes
Multiple partitions	Yes						Yes
In-memory storage mode	Yes	Yes					Yes
DirectQuery storage mode	Yes						Yes

BTW, you can also post to SSAS related forum for further support.

Regards,

Xiaoxin Sheng