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

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

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

Understanding Analysis Services Deployment Modes

SQL Server 2012 Analysis Services (SSAS) supports three different deployment modes: Multidimensional, Tabular, and SharePoint. You can choose the deployment mode during Setup, as the following figure illustrates. The SharePoint deployment mode is implicitly chosen on the Setup Role page when you install PowerPivot for SharePoint. Multidimensional and Tabular modes, on the other hand, can… Read more

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 SharePoint 2013,” discussed steps to verify that Excel Services can load workbook data models on an out-of-farm PowerPivot server running SQL Server 2012 SP1 CTP3 Analysis Services (SSAS) in SharePoint deployment mode so that users can enjoy full workbook interactivity in the browser…. Read more

Verifying the Excel Services Configuration for PowerPivot in SharePoint 2013

In SharePoint 2013, Excel Services natively supports core PowerPivot functionality. This is an important improvement over previous releases. Without requiring an extra installation of PowerPivot components in the farm, users can interact with workbook data models in the browser. You only need to register a SQL Server Analysis Services (SSAS) server in the Excel Services… Read more

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 users can seamlessly share their BI solutions with each other. In the real world, however, BI is only one of many SharePoint scenarios, albeit a mission-critical one. It is not uncommon for IT organizations to deploy multiple farms… Read more

Supporting Multiple PowerPivot Versions

Since the release of SQL Server 2012, users can choose between two different versions of PowerPivot for Excel: SQL Server 2008 R2 and SQL Server 2012. Both PowerPivot versions are free of charge, but the 2012 add-in includes more features than its predecessor and offers several improvements to the user interface, so it’s reasonable to… Read more