Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.