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 SharePoint 2016  in a demo environment based on a single-server farm. Given this paper’s high popularity, Jason then suggested that it would also be useful to provide deployment instructions for a multi-server farm with separate front-end and application… Read more

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  Microsoft SQL Server 2016 Community Technology Preview (CTP) 3.1 Feature Pack. Now customers can take advantage of SharePoint 2016 in their I-enabled farms and benefit from infrastructure advancements, compliance and security enhancements, and numerous performance and reliability improvements…. Read more

Bucketing Values in DAX

Let’s say I wanted to analyze query performance on my SQL database. I have a log that has all the queries, the time it took them to run and the total records that were returned. I want to look at how the size of the results impacts the performance of the queries. I pull my… Read more

Released: Kerberos Configuration Manager for SQL Server

Kerberos Configuration Manager for SQL Server (KerberosConfigMgr) was released on May 15th 2013, and is available for download at the Microsoft Download Center at http://www.microsoft.com/en-us/download/details.aspx?id=39046. This diagnostic tool can help to troubleshoot Kerberos-related configuration issues with SQL Server, which is very exciting for us because Kerberos authentication plays a critical role in many BI-related authentication… Read more

Released: Twitter Analytics for Excel 2013

Back in 2011, we released a great PowerPivot sample application to query Twitter and analyze tweets within Excel 2010. This was a joint venture between Microsoft and ISV Gold BI partner Extended Results, and the great news is that Extended Results has finished an updated version that now also works in Excel 2013! For all… Read more

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

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

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

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 Klout.com takes advantage of Analysis Services. Klout analyzes massive amounts of social network user data to measure the impact of opinions, links, and… Read more