Taggade inlägg: SSAS

Moving on-premises AS and RS BI solutions to Azure – and closer to Power BI

With the availability of virtual machine images for SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) in Azure Marketplace, you can now more easily migrate your AS and RS BI solutions from on-premises to Azure! This is a great opportunity to move your multidimensional workloads closer to Power BI to reduce the physical distance between your AS servers and your Power BI reports. For the same reasons, it’s also a good idea to deploy Azure VMs running SSRS in the same region as your SSAS VMs, or to migrate your paginated reports to Power BI so that your reports have the most efficient connectivity to their data models.

» Läs mer

What’s new for SQL Server 2019 Analysis Services RC1

We are excited to announce RC1 of SQL Server 2019 Analysis Services (SSAS 2019). The SSAS 2019 release is now feature complete! We may still make performance improvements for the RTM release. RC1 introduces the following features: Custom ordering of calculation items in calculation groups Query interleaving with short query bias for high concurrency workloads Online attach for optimized synchronization of read-only replicas SuperDAXMD for improved performance of Power BI reports over SSAS multidimensional Governance setting to control Power BI cache refreshes

» Läs mer