Click here to change the language.
This page is carefully and closely monitored. Any changes you make will be evaluated and then quickly accepted, refined, or reverted. Because this is a wiki, additions or refinements to these release notes might have been made by community members. To read the original release notes document, click here.
This Release Notes document describes known issues that you should read about before you install or troubleshoot the PowerPivot for Microsoft SQL Server 2012 release (download PowerPivot here). This Release Notes document is available online only, not on the installation media, and it is updated periodically.
For information about how to get started and install PowerPivot, visit PowerPivot Help , the PowerPivot Forums , and the PowerPivot Wiki portal page .
Before you install PowerPivot, read the following required actions.
You must install Visual Studio Tools for Office (VSTO) 4.0 runtime before you install PowerPivot. You can download the VSTO runtime from this Microsoft Download Center page . This is an issue for Office 2010 users only. When Office 2010 SP1 is released, a separate download of the VSTO runtime is not required.
If you do not have .NET Framework 4.0 on your computer, the SQL Server 2012 version of PowerPivot for Excel installs successfully, but the PowerPivot tab does not appear in the Excel ribbon. You must install .NET Framework 4.0.
Both PowerPivot for SharePoint and Power View include Silverlight-based components that require Silverlight 5 to be installed on the user’s computer. If you do not have the required version of Silverlight, you will be prompted to install it when you navigate to an area of the web application that requires it. You can install Silverlight 5 from http://go.microsoft.com/fwlink/?LinkId=243096.
If you plan to use SQL Server 2012 features in a SharePoint environment, then SharePoint Server 2010 Service Pack 1 (SP1) is required. We also recommend that you install the latest patches for SharePoint Server 2010 SP1.
Workaround: You must install SP1 and fully patch the server farm before you add SQL Server features to the farm. This requirement applies to the following SQL Server 2012 features:
· Using an instance of Database Engine as the farm's database server
· Configuring PowerPivot for SharePoint
· Deploying Reporting Services in SharePoint mode.
When you upgrade your existing PowerPivot for SharePoint installation to the SQL Server 2012 version of PowerPivot for SharePoint, your existing PowerPivot for SharePoint workbooks are not upgraded automatically, by default. Without an upgrade, workbooks can be used on SharePoint, but Data Refresh will fail for SQL Server 2008 R2 PowerPivot workbooks. SQL Server 2012 PowerPivot workbooks are not affected. However, you can configure an automatic upgrade feature on a PowerPivot for SharePoint instance that upgrades SQL Server 2008 R2 workbooks to the latest version, thereby enabling Data Refresh for those workbooks. For more information, see Upgrade PowerPivot for Excel and PowerPivot Data.
Workaround: If you do not want to enable PowerPivot Workbook Auto-upgrade, you must download the workbooks from SharePoint, upgrade the workbooks manually by opening them in Excel, and then upload them back onto SharePoint. The usage workbook will fail refresh, and you must upgrade it manually as well.
[TOP]
The following known issues apply to Microsoft SQL Server 2012 PowerPivot for SharePoint.
In the PowerPivot Management Dashboard, the bubble chart control does not work when the regional settings of the SharePoint server are specific to following:
· Affected format (bug shows up): day/month/year, year/day/month (Examples: European languages, Indian, etc.)
· Non-affected format (no bug): month/day/year, year/month/day (Examples: USA, Japanese, etc.)