Analysis Services (Azure)

Choosing the right Power BI platform requires understanding data management features and limitations on each platform.

The chart compares capabilities available in the four SQL Server Analysis Services hosting options.

Microsoft provides a collection of on-premises and hosted ETL offerings that vary by functionality and maturity; not all are for general use or interchangeable.

Kit brings together resources to help evaluate the various Power BI components and hosting options.

Power BI’s strategy to be a one-stop shop for BI continues with new enterprise features, support for SQL Server Analysis Services data models, and plans for external sharing.

Azure Analysis Services is retiring its Web designer tool on Mar. 1, 2019, requiring developers to adopt Visual Studio or other tools

Azure Analysis Services updates the service to SQL Server 2017, supports access to more data sources, and increases performance and scale-out for complex, distributed applications

Workloads for Azure Analysis Services (AAS) might also be suited for SQL Server Analysis Services on-premises or the Power BI Microsoft-hosted service

Roadmap for Azure Analysis Services, a Microsoft-hosted analytics service based on SQL Server Analysis Services that provides business intelligence (BI) semantic modeling.

Azure Analysis Services is a hosted version of SQL Server 2016 Analysis Services, with quick deployment and scaling options, but it has significant model and data source limitations