SQL Server 2022 BI and integration updates are mostly performance related, and some bring new opportunities for using SQL Server with Power BI and Azure.
Power BI continues to add controls that could help enterprises migrate from Analysis Services running on-premises or in 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