Refreshing PowerPivot Data in SharePoint 2013

In SharePoint 2013, Excel Services comes with numerous improvements. One of the most significant for PowerPivot is the ability to refresh data models interactively all the way from the original data sources. Unlike Excel Services in SharePoint 2010, which only queries data models but doesn’t refresh them interactively, Excel Services in SharePoint 2013 first sends… Read more

Power View for Multidimensional Models – Feature Drill Down

On 11/29 we released Preview of Power View connectivity for Multidimensional Models (a.k.a “cubes”). This is achieved through support of tabular metadata of the cube and native support of Data Analysis Expressions (DAX) queries in Analysis Services Multidimensional Models to ensure optimal performance and functionality. We will take a deeper look at how this is… Read more

BI Professional Survey

Hi everyone, We’re doing a survey of BI Professionals and we’d love to get input from you.  This survey is about tools and capabilities for SQL Server Analysis Services development. The survey is about 20 minutes long and we’d really appreciate it if you took the time to give us your feedback. The survey link… Read more

Power View for Multidimensional Models – Preview

Microsoft is offering SQL Server customers the opportunity to test and provide feedback on new functionality, Power View for Multidimensional Models. Available here, you can download and try out Power View with traditional SQL Server Analysis Services multidimensional cubes. This added functionality will help you maximize your existing BI investments while utilizing the latest BI… Read more

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 Conference. As the title suggests, the poster shows the most important technologies in the Microsoft BI stack at a glance, arranged in various layers from the data sources all the way up to the client applications… Read more

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 availability of SQL Server 2012 SP1 at the PASS Summit 2012 today. This is a significant release because it delivers important updates as well as new capabilities for Office 2013 and SQL Server 2012. We’ve already blogged… Read more

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 will go over what’s necessary to configurePowerPivot for SharePoint 2013 in a least-privileged accounts environment. Themain idea is to use different accounts for different purposes, but all of themto have the least amount of privilege as possible… Read more

Tabular Database PowerShell CmdLets available on CodePlex

JuanPablo just released an interesting cmdlet library to manage Tabular Models using PowerShell. It builds on the Tabular Model with AMO project, which JuanPablo introduced a few months ago in his blog article Creating a Tabular Model with AMO – New Version SQL 2012. So there you have it! Go to, download the compiled… Read more

More on Multiple PowerPivot Versions

The previous blog post, Supporting Multiple PowerPivot Versions, contained a PowerShell script that has proven to be very helpful for us on the product team. We get a fair number of workbooks from a variety of sources created with many different versions of PowerPivot, usually with a request for help with some problem that happened… Read more

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 (VP of Engineering, Klout) on a very interesting Big Data story about how takes advantage of Analysis Services. Klout analyzes massive amounts of social network user data to measure the impact of opinions, links, and… Read more