What is Analysis Services?

APPLIES TO: yesSQL Server Analysis Services yesAzure Analysis Services yesPower BI Premium

Analysis Services is an analytical data engine (Vertipaq) used in decision support and business analytics. It provides enterprise-grade semantic data model capabilities for business intelligence (BI), data analysis, and reporting applications such as Power BI, Excel, Reporting Services, and other data visualization tools. Analysis Services is available in different platforms:

SQL Server Analysis Services - Installed as an on-premises or VM server instance, SQL Server Analysis Services supports tabular models at all compatibility levels (depending on version), multidimensional models, data mining, and Power Pivot for SharePoint.

Azure Analysis Services - Created as an Azure resource, Azure Analysis Services server resources support tabular models at the 1200 and higher compatibility levels. DirectQuery, partitions, row-level security, bi-directional relationships, and translations are all supported. To learn more, see What is Azure Analysis Services.

Power BI Premium (Preview) - The Analysis Services Vertipaq engine provides programmability, client application, and tool support for Power BI Premium datasets at the 1500 and higher compatibility levels through client libraries and APIs that support the open-standard XMLA protocol. Power BI Premium datasets support connections through XMLA endpoints for read-only and read-write operations from Microsoft and third-party client applications and tools. To learn more, see Analysis Services in Power BI Premium and Power BI Premium dataset connectivity with the XMLA Endpoint.

Documentation

Analysis Services documentation is located at different places in docs.microsoft.com depending on the platform or version you're using. To learn more, see Understanding Analysis Services documentation.

There's more coming

We'll soon be adding more information to this article, and many others, to better describe how you can use Analysis Services to create enterprise grade BI solutions for your organization. Be sure to check back!