Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Skip to content
Permalink
main
Switch branches/tags
Go to file
 
 
Cannot retrieve contributors at this time
title description ms.date ms.prod ms.technology ms.topic ms.author ms.reviewer author monikerRange
What is Analysis Services? | Microsoft Docs
Describes the three platforms for Analysis Services.
03/30/2022
sql
analysis-services
overview
owend
owend
minewiskan
asallproducts-allversions || azure-analysis-services-current || power-bi-premium-current || >= sql-analysis-services-2016

What is Analysis Services?

[!INCLUDEappliesto-sqlas-all-aas-pbip]

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:

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 - The Analysis Services VertiPaq engine provides programmability, client application, and tool support for Power BI Premium and Premium Per User 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.

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, and Power Pivot for SharePoint.

Documentation

Analysis Services documentation is located in different areas of Microsoft Docs, depending on the platform or version you're using. To learn more, see Understanding Analysis Services documentation.