Improving Analysis Services Performance and Scalability with SQL Server 2016 Service Pack 1

SQL Server 2016 Analysis Services delivered numerous performance improvements over previous releases, such as better modeling performance thanks to the new 1200 compatibility level for tabular databases, better processing performance for tables with multiple partitions thanks to parallel partition processing, and better query performance thanks to additional DAX functions that help to optimize the client/server… Read more

Improving the Measure Grid in SSDT Tabular

As the name implies, the measure grid is an SSDT Tabular feature to define and manage measures, as illustrated in the following screenshot. It is available for each table when you work in Data View in Tabular Model Designer. You can toggle it on and off by using the Show Measure Grid option on the… Read more

Introducing Azure Analysis Services

We are pleased to announce the availability of Microsoft Azure Analysis Services preview. With Azure Analysis Services, BI professionals can create BI semantic models based on data that resides in the cloud or on-premises, whether that’s SQL Server, Azure SQL Database, Azure SQL Data Warehouse or other data sources to provide business users with a… Read more

Introducing Integrated Workspace Mode for SQL Server Data Tools for Analysis Services Tabular Projects (SSDT Tabular)

When you work with the model designer in SSDT Tabular, you are working with a temporary Analysis Services database that SSDT Tabular automatically loads on a workspace server. During the initial project creation, you must point SSDT Tabular to the desired workspace server, which must be a tabular Analysis Services instance that you can control… Read more

Introducing Tabular Model Explorer for SQL Server Data Tools for Analysis Services Tabular Projects (SSDT Tabular)

If you download and install the August 2016 release of SQL Server Data Tools (SSDT) for Visual Studio 2015, you can find a new feature in SSAS Tabular projects, called Tabular Model Explorer, which lets you conveniently navigate through the various metadata objects in a model, such as data sources, tables, measures, and relationships. It… Read more

Bidirectional cross-filtering whitepaper

Bidirectional cross-filtering is a new feature for SQL Server 2016 Analysis Services and Power BI Desktop that allows modelers to determine how they want filters to flow for data using relationships between tables. In SQL Server 2014, filter context of a table is based on the values in a related table. With bidirectional cross-filtering the… Read more

On Demand Webinar “What’s New for SQL Server 2016 Analysis Services” available now

This week I did a live webinar on what is new in  SQL Server 2016 Analysis Services: Everything you want to know about SQL Server 2016 SQL Server Analysis Service. In this session we will look at how Analysis services tabular models simplify solving complex business problems using over 50 new DAX functions and how new… Read more

What is new in SQL Server Analysis Services 2016 RC0

With the release of SQL Server 2016 RC0, we’ve added more capability for modeling and managing Tabular models set at the SQL Server 2016 compatibility level (1200). RC0 brings us one step closer to general release by adding display folders, full-fledged PowerShell support for Tabular 1200 models and instances, SSIS administration of SSAS Tabular workloads,… Read more

Try out SQL Server 2016 Analysis Services CTP 3.2 on the TechNet Virtual Lab

Recently we released a great TechNet Virtual Lab that will take you through many of the new enhancements in SQL Server 2016 Analysis Services through the great virtual environment of the TechNet labs. In this lab you will learn to: Create and monitor Extended Events (xEvents) Upgrade a tabular project to SQL Server 2016 (compatibility level 1200)… Read more

What’s new for SQL Server 2016 Analysis Services in CTP3.3

What is new in SQL Server Analysis Services 2016 CTP3.3 It is a new year and again we are delivering more updates to Analysis Services with SQL Server 2016 CTP3.3. This month’s update delivers support for calculated columns and row level security for DirectQuery, translations for Tabular models into different languages, additional performance optimizations and… Read more