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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 07/21/2017
Model Comparison and Merging for Analysis Services
Relational-database schema comparison and merging is a well-established market. Leading products...
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...
Date: 07/17/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...
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...
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...
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...
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...
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,...
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...
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...
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...
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...
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...
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...
Date: 04/19/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...
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,...
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...
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...
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...
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,...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 10/27/2016
Introducing Azure Analysis Services
We are pleased to announce the availability of Microsoft Azure Analysis Services preview. With Azure...
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...
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...
Date: 08/16/2016
Bidirectional cross-filtering whitepaper
Bidirectional cross-filtering is a new feature for SQL Server 2016 Analysis Services and Power BI...
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...
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...
Date: 03/07/2016