Configuring BI Semantic Model Connections (BISM files) to PowerPivot Workbooks in SharePoint 2013

Many customers come to us with questions surrounding the use of BISM files.  Primarily why should they use them and how to configure them.  In the following I will attempt to answer both questions. Why: When you upload a PowerPivot workbook to SharePoint, SharePoint is intelligent enough to create a Data Model under the Analysis…

0

PowerPivot Management Dashboard – Post Install Configuration

When you first install PowerPivot for SharePoint, there are some configuration tasks that need to be completed to get basic functionality working for the PowerPivot Management Dashboard, as well as to get the groundwork laid out for data refresh and slicing inside of workbooks.   While not difficult to do, these steps are often missed…

2

PowerPivot Scheduled Data Refresh: "The workbook must be checked out before it can be replaced. You can save this file with another name."

Scenario: You get the following error while running a scheduled data refresh on a PowerPivot workbook:   Problem: The "Require Check Out" option inside of the Document Library Settings > Versioning Settings of any given document library is likely set to "Yes":   Resolution: PowerPivot does not attempt to check out documents when it makes…

0

Notification messages of data update failure are not sent when you use the PowerPivot for SharePoint 2013 add-in for SQL Server 2012 SP1 or SQL Server 2014, even after installing CU7.

Issue: This issue with the email notifications was fixed with Cumulative update package 7 for SQL Server 2012 SP1, but we are seeing cases where the email notifications still do not happen, even after installing CU7 for SQL Server 2012 SP1. Cause: The PowerPivot for SharePoint update is not complete until the PowerPivot Configuration Tool…

1

PowerPivot for SharePoint – "An error occurred when loading the Sandbox cube"

You may receive an error similar to the following when running a scheduled data refresh of a PowerPivot workbook in SharePoint: The table with ID of '<TableID>', Name of '<TableName>' referenced by the 'Sandbox' cube, does not exist. An error occurred when loading the Sandbox cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.POWERPIVOT\OLAP\Backup\Sandboxes\PowerPivotServiceApplication\<GUID>.db\Sandbox.9825.cub.xml'. You might…

0

FIXED – PowerPivot Scheduled Data Refresh – Call to Excel Services returned an error.

This issue is fixed in SharePoint 2013 SP1 (Released Feb 25th 2014): Update center for Office, Office servers, and related productshttp://technet.microsoft.com/en-US/office/ee748587.aspx    Issue: "Call to Excel Services returned an error" when performing a Scheduled Data Refresh. In the ULS logs,  you will see: w3wp.exe (0x0A28)            0x0DB8  PowerPivot Service             Data Refresh        99           High                EXCEPTION: System.InvalidOperationException: Call to Excel…

8

Excel Services 2013 issue with IE 11.0.9600.16438 – UPDATE

There appears to be an issue with SharePoint 2013 Excel Services when using IE 11 (11.0.9600.16438).  As noted in the comments below, the issue is resolved by installing the October 2013 Cumulative Update for SharePoint 2013: Description of the SharePoint Server 2013 cumulative update package (SharePoint server-package): October 26, 2013 http://support.microsoft.com/default.aspx?scid=kb;EN-US;2825647 See this blog for detail…

12

"Cannot convert claims to windows token" "Could not retrieve a valid windows identity " "UPN is required when Kerberos constrained delegation is used"

For awhile now, we here at PowerPivot for SharePoint Support have seen a variety of Claims Identity/Windows Token/UPN errors.  Primarily with PowerPivot failing to refresh a workbook in the browser. But recently, I noticed another product presenting this error. In the ULS logs, you will see: 10/29/2013 10:11:28.57 w3wp.exe (0x1DA4) 0x33F4 SharePoint Foundation Claims Authentication bz7l Medium SPSecurityContext.WindowsIdentity: Could not retrieve a…

3

What is PowerPivot for SharePoint? Part 1.

I find myself explaining PowerPivot to customers over and over.  Most understand parts of how it works but not the whole story.  I will touch on two parts; PowerPivot for Excel and PowerPivot for SharePoint. Part 1: PowerPivot for Excel PowerPivot for SharePoint is nothing without the Excel Rich Client and the PowerPivot Add-in.  Pre-Excel…

0

PowerPivot for SharePoint – Schedule Data Refresh Error: "A schedule cannot be enabled for a workbook with no external data sources."

If you come across this error when trying to perform a scheduled data refresh: “A schedule cannot be enabled for a workbook with no external data sources.” This is because the Data Model cannot be created on the PowerPivot Server. Your probably have two questions. 1. What is a “Data Model”. The Data Model is…

9