Analysis Services Team Blog

Information, tips, news and announcements about Azure Analysis Services (Azure AS) and SQL Server Analysis Services (SSAS) directly from the product team.

Future Analysis Services posts on Power BI blog

The Analysis Services Team Blog has served as the medium for many historic announcements and updates...

Author: Christian Wade Date: 04/26/2019

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...

Author: Christian Wade Date: 03/26/2019

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...

Author: Christian Wade Date: 03/01/2019

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...

Author: Christian Wade Date: 08/08/2018

New memory options for Analysis Services

We’re happy to introduce some new memory settings for Azure Analysis Services and SQL Server...

Author: Christian Wade Date: 06/08/2018

Automation of Analysis Services with NuGet packages

We are pleased to announce that the Analysis Services Management Objects (AMO) and ADOMD client...

Author: Christian Wade Date: 02/10/2018

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...

Author: Christian Wade Date: 12/20/2017

Using Legacy Data Sources in Tabular 1400

The modern Get Data experience in Tabular 1400 brings interesting new data discovery and...

Author: KayUnkroth Date: 09/12/2017

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...

Author: KayUnkroth Date: 09/05/2017

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...

Author: KayUnkroth Date: 08/28/2017

Deploying Analysis Services and Reporting Services Project Types in Visual Studio 2017

(Co-authored by Mike Mallit) SQL Server Data Tools (SSDT) adds four different project types to...

Author: KayUnkroth Date: 08/23/2017

Online Analysis Services Course: Developing a Multidimensional Model

Check out the excellent, new online course by Peter Myers and Chris Randall for Microsoft Learning...

Author: Christian Wade Date: 07/21/2017

Model Comparison and Merging for Analysis Services

Relational-database schema comparison and merging is a well-established market. Leading products...

Author: Christian Wade Date: 07/19/2017

What’s new in SQL Server 2017 RC1 for Analysis Services

The RC1 public preview of SQL Server 2017 is available here! It includes Dynamic Management View...

Author: Christian Wade Date: 07/17/2017

Building an Azure Analysis Services Model on Top of Azure Blob Storage—Part 3

Part 2 finished with the deployment of a scalable Tabular 1400 model in Azure Analysis Services on...

Author: KayUnkroth Date: 06/22/2017

Update to Auto-Partitioning Code Sample & Whitepaper

A new version of the whitepaper and code sample of automated partition management (see here for more...

Author: Christian Wade Date: 05/30/2017

Building an Azure Analysis Services Model on Top of Azure Blob Storage—Part 2

The first part in this series covering Azure Analysis Services models on top of Azure Blob Storage...

Author: KayUnkroth Date: 05/30/2017

What’s new in SQL Server 2017 CTP 2.1 for Analysis Services

The public CTP 2.1 of SQL Server 2017 is available here! This public preview includes the following...

Author: Christian Wade Date: 05/18/2017

Building an Azure Analysis Services Model on Top of Azure Blob Storage—Part 1

In a comment to a recent blog article, Bill Anton raised a question about the target scenarios for...

Author: KayUnkroth Date: 05/15/2017

1400 Compatibility Level in Azure Analysis Services

We are excited to announce the public preview of the 1400 compatibility level for tabular models in...

Author: Christian Wade Date: 05/04/2017

Join Alberto Cairo at the Microsoft Data Insights Summit to Explore the Different Dimensions of Data Visualization

Known for his award-winning global achievements in infographics and multimedia as a professor,...

Author: Christian Wade Date: 05/02/2017

SSMS Improvements for Analysis Services in the April 2017 Release

The April 2017 Release of SSMS for Analysis Services is the first release with support for the...

Author: KayUnkroth Date: 04/26/2017

What’s new in SQL Server 2017 CTP 2.0 for Analysis Services

The public CTP 2.0 of SQL Server 2017 on Windows is available here! This public preview includes the...

Author: Christian Wade Date: 04/19/2017

Introducing a DAX Editor Tool Window for SSDT Tabular

The April 2017 release of SSDT Tabular for Visual Studio 2015 and 2017 comes with a DAX editor tool...

Author: KayUnkroth Date: 04/19/2017

New Get Data Capabilities in the GA Release of SSDT Tabular 17.0 (April 2017)

With the General Availability (GA) release of SSDT 17.0, the modern Get Data experience in Analysis...

Author: KayUnkroth Date: 04/19/2017

Introducing DirectQuery Support for Tabular 1400

With the production release of SSDT 17.0, Tabular projects now support DirectQuery mode at the 1400...

Author: KayUnkroth Date: 04/19/2017

Meet the Azure Analysis Services team at upcoming user group meetings

Come meet the Analysis Services team in person as they answer your questions on Analysis Services in...

Author: Josh Caplan -MSFT Date: 04/19/2017

Learn how to “think like a Freak” with Freakonomics authors at Microsoft Data Insights Summit

With more than 5 million copies sold in 40 countries, Freakonomics is a worldwide phenomenon — and...

Author: Christian Wade Date: 04/10/2017

DirectQuery in SQL Server 2016 Analysis Services whitepaper

I am excited to announce the availability of a new whitepaper called "DirectQuery in SQL Server 2016...

Author: Kasper de Jonge [MSFT] Date: 04/06/2017

Learn about Azure Analysis Services at the Microsoft Data Insights Summit 2017

We’re excited to participate in the Microsoft Data Insights Summit June 12 – 13, 2017 in Seattle,...

Author: Christian Wade Date: 03/22/2017

Online Analysis Services Course: Developing a Tabular Model

Check out the excellent, new online course by Peter Myers and Chris Randall for Microsoft Learning...

Author: Christian Wade Date: 03/22/2017

What makes a Data Source a Data Source?

It should be obvious, and it is — at least at the Tabular 1200 compatibility level: A data source...

Author: KayUnkroth Date: 03/15/2017

SSMS DAX Query Editor

We are excited to announce the SQL Server Management Studio DAX Query Editor! Have you ever authored...

Author: Christian Wade Date: 03/14/2017

Introducing SQL Server Data Tools for Analysis and Reporting Services for Visual Studio 2017

Visual Studio 2017 brings improvements to performance, navigation, IntelliSense, Azure development,...

Author: Christian Wade Date: 03/09/2017

Encoding Hints and SQL Server Analysis Services vNext CTP 1.3

The public CTP 1.3 of SQL Server vNext on Windows is available here! The corresponding versions of...

Author: Christian Wade Date: 02/17/2017

Released: SQL Server Data Tools 17.0 RC 2

SQL Server Data Tools 17.0 Release Candidate 2 (RC 2) has just been published. You can download and...

Author: KayUnkroth Date: 02/03/2017

Whitepaper and Code Sample for Automated Partition Management

Analysis Services tabular models can store data in a highly-compressed, in-memory cache for...

Author: Christian Wade Date: 01/17/2017

ASTrace on the Analysis Services Git Repo

The ASTrace utility provides the ability to capture an Analysis Services trace and log it into a SQL...

Author: Christian Wade Date: 01/17/2017

Evaluating Shared Expressions in Tabular 1400 Models

In our December blog post; Introducing a Modern Get Data Experience for SQL Server vNext on Windows...

Author: KayUnkroth Date: 12/30/2016

What’s new for SQL Server vNext on Windows CTP 1.1 for Analysis Services

The public CTP 1.1 of SQL Server vNext on Windows is available here! This public preview includes...

Author: Christian Wade Date: 12/16/2016

Introducing a Modern Get Data Experience for SQL Server vNext on Windows CTP 1.1 for Analysis Services

Starting with SQL Server vNext on Windows CTP 1.1, Analysis Services features a modern connectivity...

Author: KayUnkroth Date: 12/16/2016

How SQL Server 2016 and Power BI empower Mediterranean Shipping Company (MSC)

Here’s a great case study about Mediterranean Shipping Company optimizing their business processes...

Author: KayUnkroth Date: 12/09/2016

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

SQL Server 2016 Analysis Services delivered numerous performance improvements over previous...

Author: KayUnkroth Date: 11/17/2016

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...

Author: KayUnkroth Date: 10/27/2016

Introducing Azure Analysis Services

We are pleased to announce the availability of Microsoft Azure Analysis Services preview. With Azure...

Author: KayUnkroth Date: 10/25/2016

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...

Author: KayUnkroth Date: 09/20/2016

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...

Author: KayUnkroth Date: 08/16/2016

Bidirectional cross-filtering whitepaper

Bidirectional cross-filtering is a new feature for SQL Server 2016 Analysis Services and Power BI...

Author: Kasper de Jonge [MSFT] Date: 06/24/2016

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...

Author: Kasper de Jonge [MSFT] Date: 03/25/2016

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...

Author: Kasper de Jonge [MSFT] Date: 03/07/2016

Next>