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

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 Server components, SP1 is just a collection of patches and bug fixes, but for Business Intelligence scenarios, SP1 is much more than just a service pack. SQL Server 2012 SP1 CTP3 is specifically released to accompany the… Read more

Exploring the PowerPivot for SharePoint Configuration Tool

The PowerPivot Configuration Tool included in SQL Server Code Name “Denali” CTP3 is undoubtedly a great new utility for SharePoint administrators. This tool doesn’t just enable you to configure or upgrade PowerPivot in a SharePoint farm. It takes PowerPivot configuration to a whole new level. Here are some key improvements in comparison to what’s available… Read more

Released: SQL Server Code Name “Denali” CTP3 Product Guide

Looking for datasheets, white papers, click-through and auto-running demonstrations, hands-on lab previews, technical presentations, and other useful links to evaluate SQL Server Code Name ‘Denali’ CTP3? Go to the Microsoft Download Center and search for “CTP3 Product Guide” or simply click on the following link: The SQL Server Denali CTP3 Product Guide includes the… Read more

Analysis Services Blog Post Roundup for Denali CTP3

A few AS team members have started blogging on Denali functionality at their personal blog sites. Cathy Dumas, a Program Manager on our team, is just warming up on her blog. She’s got a couple of interesting posts: Tabular designer architecture Tabular project structure  Kasper de Jonge, another Program Manager on our team, has been… Read more

Submit Your Feedback on Analysis Services and PowerPivot

Now that the Microsoft SQL Server Code Name “Denali” Evaluation edition is available for download, we are eager to hear from you. Do you like the new Business Intelligence (BI) features, such as the new professional BI developer tools? Do you find it easy to create tabular models on an Analysis Services server? What additional… Read more

Announcing Microsoft SQL Server Code Name “Denali” Community Technology Preview 3 (CTP3)

Today we released our next public CTP of Microsoft SQL Server Code Name “Denali.” This milestone is super exciting because it is packed with amazing Business Intelligence (BI) improvements and innovations for relational databases as well as for BI solutions. You can find the Denali CTP Evaluation edition at the Download Center. Try it… Read more