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.
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...
Author: Kasper de Jonge [MSFT] Date: 02/19/2016
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...
Author: Kasper de Jonge [MSFT] Date: 02/03/2016
Second White Paper Published: Deploying SQL Server 2016 PowerPivot and Power View in a Multi-Tier SharePoint 2016 Farm
Last month, we published a white paper about Deploying SQL Server 2016 PowerPivot and Power View in...
Author: KayUnkroth Date: 01/19/2016
What’s new for SQL Server 2016 Analysis Services in CTP3.2
What is new in SQL Server Analysis Services 2016 CTP3.2 Just a few weeks after releasing SQL Server...
Author: Kasper de Jonge [MSFT] Date: 12/17/2015
White Paper Published: Deploying SQL Server 2016 PowerPivot and Power View in SharePoint 2016
The PowerPivot add-in for SharePoint Server 2016 was published for the first time as part of the...
Author: KayUnkroth Date: 12/08/2015
What’s new for SQL Server 2016 Analysis Services in CTP3.1
After last month’s SQL Server Analysis Services 2016 CTP3 we are shipping yet again this...
Author: Kasper de Jonge [MSFT] Date: 11/30/2015
What’s new for SQL Server 2016 Analysis Services in CTP3
We are really excited to announce the SQL Server 2016 Analysis Services CTP 3 update can be...
Author: Kasper de Jonge [MSFT] Date: 10/28/2015
Using Extended Events with SQL Server Analysis Services 2016 CTP 2.3
Extended Events were introduced into Analysis Services in SQL Server 2012. This made use of a common...
Author: Adam W. Saxton Date: 09/22/2015
Parallel partition processing available for Tabular Models in SQL Server 2016 Preview
One of the great new features that was actually added back in CTP 2.0 of SQL Server 2016 Preview is...
Author: Kasper de Jonge [MSFT] Date: 09/16/2015
SQL Server Analysis Service 2016 CTP 2.3 DirectQuery in action
In my previous blog post “What’s new in Microsoft SQL Server Analysis Services Tabular...
Author: Kasper de Jonge [MSFT] Date: 09/08/2015
What’s New in Microsoft SQL Server Analysis Services Tabular models in SQL Server 2016 CTP 2.3
This is an exciting time for SQL Server Analysis Services as we start to release updates to our...
Author: Kasper de Jonge [MSFT] Date: 09/02/2015
Data mining and Power Pivot for Excel 2010 add-in issues with Windows 10 and Visual Studio 2015
Update: Download the latest version of Data Mining add ins here that solve this issue. Unfortunately...
Author: Kasper de Jonge [MSFT] Date: 08/05/2015
Calendar Reporting with Excel and Power Pivot
Imagine that you wanted to see a daily sales report for each day that also included month to date...
Author: Josh Caplan -MSFT Date: 06/24/2014
Bucketing Values in DAX
Let’s say I wanted to analyze query performance on my SQL database. I have a log that has all...
Author: Josh Caplan -MSFT Date: 06/05/2014
SQL Server Data Tools – Business Intelligence for Visual Studio 2013 (SSDT BI)
Yesterday we released SQL Server Data Tools – Business Intelligence for Visual Studio 2013...
Author: Kasper de Jonge [MSFT] Date: 04/02/2014
Released: Management Pack for SQL Server Analysis Services 2008 and 2012
This week, we released Management Packs for SQL Server 2008 and 2012 Analysis Services. The...
Author: KayUnkroth Date: 01/31/2014
SQL Server Data Tools – Business Intelligence (SSDT BI) for SQL Server 2014 CTP1
In this pre-release version of SQL Server 2014, SSDT BI is no longer included in setup. For SQL...
Author: Eswar Perla Date: 07/02/2013
Power View connectivity for Multidimensional Models released
On November 29, 2012 we released the “Power View for Multidimensional Models --...
Author: Siva Harinath Date: 05/31/2013
Released: Kerberos Configuration Manager for SQL Server
Kerberos Configuration Manager for SQL Server (KerberosConfigMgr) was released on May 15th 2013, and...
Author: KayUnkroth Date: 05/23/2013
Profit and Loss Data Modeling and Analysis with Microsoft PowerPivot in Excel
Accounting and Finance Professionals have a new learning resource. The Profit and Loss Data Modeling...
Author: Kasper de Jonge [MSFT] Date: 05/14/2013
Released: Twitter Analytics for Excel 2013
Back in 2011, we released a great PowerPivot sample application to query Twitter and analyze tweets...
Author: KayUnkroth Date: 03/15/2013
SQL Server Data Tools – Business Intelligence for Visual Studio 2012 released online
Today we are releasing SQL Server Data Tools – Business Intelligence for Visual Studio 2012...
Author: Kasper de Jonge [MSFT] Date: 03/06/2013
What is new for the Tabular model in SQL Server 2012 SP1 and compatibility level
On the surface the SQL Server 2012 SP1 looks very much like SQL Server 2012 RTM but there are some...
Author: Kasper de Jonge [MSFT] Date: 01/04/2013
Refreshing PowerPivot Data in SharePoint 2013
In SharePoint 2013, Excel Services comes with numerous improvements. One of the most significant for...
Author: KayUnkroth Date: 12/21/2012
BI Professional Survey
Hi everyone, We’re doing a survey of BI Professionals and we’d love to get input from...
Author: T.K. Anand Date: 11/30/2012
Power View for Multidimensional Models - Preview
Microsoft is offering SQL Server customers the opportunity to test and provide feedback on new...
Author: T.K. Anand Date: 11/29/2012
Poster Download: Microsoft Business Intelligence at a Glance
Over recent months, we had a lot of fun creating a Microsoft BI poster for SQL Pass and SharePoint...
Author: KayUnkroth Date: 11/26/2012
Announcing Microsoft SQL Server 2012 Service Pack 1 (SP1)
This was a big day for us as Ted Kummert (Vice President for SQL Server) announced the general...
Author: KayUnkroth Date: 11/07/2012
Configuring a Min-priv environment for PowerPivot for SharePoint 2013
The new SharePoint 2013 release is bringing lots of excitingnew things, and on this blog post we...
Author: Mariano Teixeira Neto [MSFT] Date: 11/05/2012
Tabular Database PowerShell CmdLets available on CodePlex
JuanPablo just released an interesting cmdlet library to manage Tabular Models using PowerShell. It...
Author: KayUnkroth Date: 10/02/2012
More on Multiple PowerPivot Versions
The previous blog post, Supporting Multiple PowerPivot Versions, contained a PowerShell script that...
Author: Ron Pihlgren [MSFT] Date: 10/01/2012
SQL Server Analysis Services and Big Data
Over the past few weeks, I had an opportunity to work with colleague Denny Lee and David P Mariani...
Author: KayUnkroth Date: 09/26/2012
Announcing Microsoft SQL Server 2012 Service Pack 1 (SP1) Community Technology Preview 4 (CTP4)
Last Thursday, we released SQL Server 2012 Service Pack 1 (SP1) CTP4. Both the Service Pack and...
Author: KayUnkroth Date: 09/24/2012
Setting Up an Administrative Server for BI in SharePoint 2013
SharePoint has practically always relied on a Central Administration Web site to provide a...
Author: KayUnkroth Date: 08/20/2012
Understanding Analysis Services Deployment Modes
SQL Server 2012 Analysis Services (SSAS) supports three different deployment modes:...
Author: KayUnkroth Date: 08/17/2012
Troubleshooting PowerPivot for SharePoint Solution Deployments
The configuration of PowerPivot for SharePoint entails a critical phase concerning the deployment of...
Author: KayUnkroth Date: 08/14/2012
Getting Started with Row Level Security
In this article, I will use the following features: Parent Child Relationships, Row Level Security...
Author: BradleyOuellette Date: 08/10/2012
Verifying the SharePoint 2013 Configuration for Accessing Workbooks as a Data Source from Within the Farm
My previous blog post, “Verifying the Excel Services Configuration for PowerPivot in...
Author: KayUnkroth Date: 08/06/2012
Verifying the Excel Services Configuration for PowerPivot in SharePoint 2013
In SharePoint 2013, Excel Services natively supports core PowerPivot functionality. This is an...
Author: KayUnkroth Date: 08/02/2012
Introducing the BI Light-Up Story for SharePoint 2013
Ideally, you can find the Microsoft BI stack in every SharePoint farm across the enterprise so that...
Author: KayUnkroth Date: 07/27/2012
Going All In with Excel 2013
PowerPivot for Excel, first introduced with SQL Server 2008 R2 in April of 2010, opened...
Author: Julie Strauss [MSFT] Date: 07/26/2012
Announcing Microsoft SQL Server 2012 Service Pack 1 (SP1) Community Technology Preview 3 (CTP3)
Last week, we released the public CTP of Microsoft SQL Server 2012 Service Pack 1. For most SQL...
Author: KayUnkroth Date: 07/23/2012
Supporting Multiple PowerPivot Versions
Since the release of SQL Server 2012, users can choose between two different versions of PowerPivot...
Author: KayUnkroth Date: 07/18/2012
xVelocity and Analysis Services
Along with the SQL Server 2012 launch, Microsoft announced xVelocity in-memory technologies,...
Author: KayUnkroth Date: 03/09/2012
SQL Server 2012 Released: Eval version available immediately, general availability in April
This is it! Microsoft SQL Server 2012 has been released to manufacturing (RTM), with an evaluation...
Author: KayUnkroth Date: 03/06/2012
Quick Start Guide Released: Learn DAX Basics in 30 Minutes
Never had the time to learn DAX? Now is the time!Author Owen Duncan just released a DAX 101 course...
Author: KayUnkroth Date: 01/26/2012
Removing VSTO-Based Customizations from a PowerPivot Workbook
This article is a follow-up on a previous blog post titled “How to Build a VSTO-Based...
Author: KayUnkroth Date: 01/06/2012
Whitepaper and Samples Released: Data Analysis Expressions (DAX) In the Tabular BI Semantic Model
Happy New Year 2012, everybody! With the release of SQL Server 2012 ante portas, this is going to be...
Author: KayUnkroth Date: 01/04/2012
Announcing Microsoft SQL Server 2012 Release Candidate 0 (RC0)
Today, we’ve reached the next big milestone on the road to unlocking breakthrough insights...
Author: KayUnkroth Date: 11/17/2011