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

Power View for Multidimensional Models - Feature Drill Down

On 11/29 we released Preview of Power View connectivity for Multidimensional Models (a.k.a...

Author: T.K. Anand Date: 12/09/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

<Previous Next>