Browse by Tags

Blog Post: BISM icons not present in SharePoint 2013 Library

Tom S - MSFT

We have worked several cases where BISM icons are no longer present in a SharePoint Library. In the below screenshot you can see the icon is a blank square. We have found that the mapping is no longer present in the DOCICON located in one of the two directories (dependant on the version you...

on 16 Dec 2014
Blog Post: Configuring BI Semantic Model Connections (BISM files) to PowerPivot Workbooks in SharePoint 2013

Tom S - MSFT

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...

on 15 Dec 2014
Blog Post: PowerPivot Management Dashboard - Post Install Configuration

RickA - MSFT

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...

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

RickA - MSFT

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": ...

on 15 Sep 2014
Blog Post: 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.

Jason Sc - MSFT

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...

on 13 Aug 2014
Blog Post: PowerPivot for SharePoint - "An error occurred when loading the Sandbox cube"

Zakir H - MSFT

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...

on 29 Jan 2014
Blog Post: FIXED - PowerPivot Scheduled Data Refresh - Call to Excel Services returned an error.

Tom S - MSFT

This issue is fixed in SharePoint 2013 SP1 (Released Feb 25th 2014): Update center for Office, Office servers, and related products http://technet.microsoft.com/en-US/office/ee748587.aspx Issue: " Call to Excel Services returned an error " when performing a Scheduled Data Refresh....

on 20 Dec 2013
Blog Post: PowerPivot Workbooks as a Data Source

Dan F. - Microsoft Support

We have been seeing some issues with customers using PowerPivot workbooks as a source file in new Excel PowerPivot files. There are a variety of errors that can arise from this process, and this blog is intended to provide you with some troubleshooting steps to resolve the issue. You may or may not...

on 15 Feb 2013
Blog Post: Excel Services - Using a SharePoint List as a data source

Tom S - MSFT

Since Excel Services inception (SharePoint 2007) users have been attempting to consume a SharePoint List in Excel Services. Unfortunately this is not supported. I will explain why and I will also provide a workaround using PowerPivot. If you are unsure whether or not you are using a SharePoint list...

on 11 Jul 2013
Blog Post: What is PowerPivot for SharePoint? Part 1.

Tom S - MSFT

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...

on 1 Oct 2013
Blog Post: PowerPivot for SharePoint - Gallery Thumbnails Not Rendering

Tom S - MSFT

Many customers have reported after uploading a workbook to the PowerPivot Gallery, the thumbnails are not rendering: Snapshots will not work if you have chosen to open the workbooks in the Client application. To remedy this, follow the below instructions: To set the default open behavior for...

on 27 Dec 2012
Blog Post: Upsizing PowerPivot 2013 Workbooks to SSAS for Knowledge Workers

Warren_R_Msft

Much of the existing content for converting a PowerPivot workbook to a SQL Server Analysis Services (SSAS) tabular instance assumes that the reader is a developer. This post details the process of upsizing a PowerPivot workbook to SSAS from the point of view of a knowledge worker and or a SharePoint...

on 23 May 2013
Blog Post: Excel Services 2013 issue with IE 11.0.9600.16438 - UPDATE

Dan F. - Microsoft Support

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...

on 21 Nov 2013
Blog Post: "Cannot convert claims to windows token" "Could not retrieve a valid windows identity " "UPN is required when Kerberos constrained delegation is used"

Tom S - MSFT

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: ...

on 29 Oct 2013
Blog Post: 3 Things you may/may not know about PowerPivot-AS for SharePoint 2013

Tom S - MSFT

The following applies to SharePoint 2013: 1. Restarting ECS will force a wipe and reload of PowerPivot databases. 2. Any service account needing to interact with the PowerPivot data model needs to be an Administrator on the PowerPivot AS instance. This is less obvious when you are in a client application...

on 2 Apr 2013
Blog Post: PowerPivot for SharePoint - Schedule Data Refresh Error: "A schedule cannot be enabled for a workbook with no external data sources."

Tom S - MSFT

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...

on 1 Oct 2013

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

Excel Services & PowerPivot for SharePoint

Browse by Tags

Blog Post: BISM icons not present in SharePoint 2013 Library

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

Blog Post: PowerPivot Management Dashboard - Post Install Configuration

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

Blog Post: 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.

Blog Post: PowerPivot for SharePoint - "An error occurred when loading the Sandbox cube"

Blog Post: FIXED - PowerPivot Scheduled Data Refresh - Call to Excel Services returned an error.

Blog Post: PowerPivot Workbooks as a Data Source

Blog Post: Excel Services - Using a SharePoint List as a data source

Blog Post: What is PowerPivot for SharePoint? Part 1.

Blog Post: PowerPivot for SharePoint - Gallery Thumbnails Not Rendering

Blog Post: Upsizing PowerPivot 2013 Workbooks to SSAS for Knowledge Workers

Blog Post: Excel Services 2013 issue with IE 11.0.9600.16438 - UPDATE

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

Blog Post: 3 Things you may/may not know about PowerPivot-AS for SharePoint 2013

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