Future Analysis Services posts on Power BI blog

The Analysis Services Team Blog has served as the medium for many historic announcements and updates in Microsoft BI over the past 10 years. Well, Microsoft is moving off MSDN and TechNet blogs, so this will be the last post on this blog site. The site, including all historical posts, will remain online as a… Read more

What’s new for SQL Server 2019 Analysis Services CTP 2.4

We are excited to announce the public CTP 2.4 of SQL Server 2019 Analysis Services. This public preview includes the following enhancements for Analysis Services tabular models. Many-to-many relationships Memory settings for resource governance Many-to-many relationships Many-to-many (M2M) relationships in CTP 2.4 are based on M2M relationships in Power BI described here. M2M relationships in… Read more

What’s new for SQL Server 2019 Analysis Services CTP 2.3

We find great pleasure in announcing the public CTP 2.3 of SQL Server 2019 Analysis Services. New features detailed here are planned to ship later in Power BI Premium and Azure Analysis Services. Calculation groups Here is a question for seasoned BI professionals: what is the most powerful feature of SSAS multidimensional? Many would say… Read more

Whitepaper on modeling for AS tabular scalability

This is a guest post from Daniel Rubiolo of the Power BI Customer Advisory Team (PBI CAT). To scale Tabular models to very big volumes of data, and with the objective of getting as much of the data as possible into memory so users can consume it in their analyses, we must consider data preparation and… Read more

New memory options for Analysis Services

We’re happy to introduce some new memory settings for Azure Analysis Services and SQL Server Analysis Services tabular models. These new settings are primarily for resource governance, and in some cases can speed up data refresh. IsAvailableInMdx The IsAvailableInMdx column property is available in Azure Analysis Services and SQL Server Analysis Services 2017 CU7. It… Read more

Automation of Analysis Services with NuGet packages

We are pleased to announce that the Analysis Services Management Objects (AMO) and ADOMD client libraries are now available from NuGet.org! This simplifies the development and management of automation tasks for Azure Analysis Services and SQL Server Analysis Services. NuGet provides benefits including the following. Azure Functions require less manual intervention to work with Azure… Read more

Asynchronous Refresh with the REST API for Azure Analysis Services

We are pleased to introduce the REST API for Azure Analysis Services. Using any programming language that supports REST calls, you can now perform asynchronous data-refresh operations. This includes synchronization of read-only replicas for query scale out. Data-refresh operations can take some time depending on various factors including data volume and level of optimization using… Read more

Using Legacy Data Sources in Tabular 1400

The modern Get Data experience in Tabular 1400 brings interesting new data discovery and transformation capabilities to Analysis Services. However, not every BI professional is equally excited. Especially those who prefer to build their models exclusively on top of SQL Server databases or data warehouses and appreciate the steadiness of tried and proven T-SQL queries… Read more

Using Azure Analysis Services on Top of Azure Data Lake Store

The latest release of SSDT Tabular adds support for Azure Data Lake Store (ADLS) to the modern Get Data experience (see the following screenshot). Now you can augment your big data analytics workloads in Azure Data Lake with Azure Analysis Services and provide rich interactive analysis for selected data subsets at the speed of thought!… Read more

Supporting Advanced Data Access Scenarios in Tabular 1400 Models

In the context of this blog article, advanced data access scenarios refers to situations where data access functions inside M expressions cannot easily be represented through data source definitions in Tabular metadata. These scenarios are predominantly encountered when copying and pasting complex M expressions from an Excel workbook or a Power BI Desktop file into… Read more