TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Internet Explorer
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Lync
See all products »
Resources
Curah! curation service
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Subscriptions
TechNet Video
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Microsoft Update
Trials
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Related Sites
Microsoft Download Center
TechNet Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
e-Learning overview
Certifications
Certification overview
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Other resources
TechNet Events
Second shot for certification
Born To Learn blog
Find technical communities in your area
Support options
For small and midsize businesses
For enterprises
For developers
For IT professionals
From partners
For technical support
Support offerings
For home users
More support
Microsoft Premier Online
Microsoft Fix It Center
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Excel Services & PowerPivot for SharePoint
Troubleshooting Excel Services and PowerPivot for SharePoint rendering and refreshing in the browser.
Tags
2010
2013
AJAX
An error occurred
An error occurred while capturing snapshots of this document
bad request
BIG IP
BISM
BISM Icon Missing
black background
blacking out
blank
browser
Call to Excel Services returned an erorr
configuration
Constrained delegation
Couldn't Open the Workbook
Dashboard
Data Connetions
Data Model
Data Refresh Failed
Data Refresh Fails
Delegation
email
Enterprise Application Definition
Excel Services
Excel Web Access web part
Excel Web Access Web Parts
External Data Refresh Failed
fail
Failed to Refresh
Fails
failure
Farm Solutions
feature.xml
Getsnapshot.exe
How to Configure Kerberos for Excel Services
IBMDB2
Icon
Icons not rendering
IE 11
Install
Interactive Refresh
Kerberos
Kerberos Configuration for Excel Services
Kerberos.dll
List
list template is not installed in this farm
Loading
Maximum Private Bytes Exceeded
missing
MSOLAPDisco.3
not working
Notification messages of data update failure are not sent
Office Web Apps
Office Web Apps 2013
OLEDBConnection::InitConnection: The following system error occurred: The function requested is not supported
performance point
PowerPivot
PowerPivot 2013
PowerPivot for SharePoint
PowerPivot Gallery
PowerPivot Management Dashboard Processing Timer Job
PowerView
PowerView Fails to Open
Process
Recycle
Red X
refresh
Refresh all Connection
Refresh Fails
Refresh in Browser
rsClaimsToWindowsTokenError
Schedule Details
Scheduled Data Refresh
Secure Store
SharePoint
SharePoint 2010
SharePoint 2013
SharePoint List
Shutdown was initiated due to an error
SnapShot
Snapshots
SPNs
SQL
SQL Credentials
SQL Reporting Services
SSS ID
Supression
Team Foundation Server
Teradata
The workbook cannot be opened
ThisWorkbookDataModel
thumbnails
Unable to complete the operation
Unable to get the required information about this cube. The cube might have been reorganized or changed on the server. The PivotTable was not refreshed
Unable to Process the Request
Unable to refresh data
What is PowerPivot
What is PowerPivot for SharePoint
Browse by Tags
TechNet Blogs
»
Excel Services & PowerPivot for SharePoint
»
All Tags
»
powerpivot for sharepoint
Related Posts
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 workbook with a PowerPivot connection to a SharePoint list cannot be refreshed manually in the browser (Data > Refresh All Connections) using Windows authentication in SharePoint 2013
Jason Sc - MSFT
Issue As we all know :) with SharePoint 2013, manual data refresh in the browser (Data > Refresh All Connections) for PowerPivot workbooks will refresh data all the way back from the original PowerPivot data source, which is specified in the PowerPivot workbook's PowerPivot connection. This...
on
15 Oct 2014
Blog Post:
"PowerPivot Management Dashboard ProcessingTimer Job" throws error "User cannot be found”.
Warren_R_Msft
Issue Overview: Post migration of a working PowerPivot system from Windows Authentication to Claims Authentication sometimes not all workbook files author property is updated to the new format, this causes the "PowerPivot Management Dashboard Processing Timer Job" to fail with error: ...
on
13 Aug 2014
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:
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:
Tools and Techniques: Troubleshooting Kerberos in Excel Services and PowerPivot for SharePoint
Tom S - MSFT
I have troubleshot many Kerberos cases over the years and here are the best techniques and tools that I have used over the years. 1. Kerberos Event Logging (KB here ): Add the following registry value to each machine in the farm that receives Kerberos Traffic: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet...
on
8 Feb 2013
Blog Post:
What is PowerPivot for SharePoint? Part 2.
Tom S - MSFT
Now that we have a PowerPivot workbook in the Excel Rich Client, we are ready to publish that workbook to SharePoint. In " What is Power Pivot for SharePoint? Part 1 " I discussed the Data Model and how it is a database inside of Excel. When you publish/upload a regular Excel workbook to SharePoint...
on
10 Oct 2013
Blog Post:
PowerPivot 2013 for SharePoint - "External Data Refresh Failed" using Interactive Data Refresh via "Use the authenticated user's account"
Tom S - MSFT
When refreshing in the browser you may come across this error: "External Data Refresh Failed An error occurred while working on the Data Model in the workbook. Please try again. We were unable to refresh one or more data connections in this workbook. The following connections failed to refresh...
on
1 Feb 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:
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:
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 - Browser Refresh Fails (Data Refresh not supported in Office Web Apps)
Tom S - MSFT
We have been seeing Excel Services/PowerPivot data refresh issues using SharePoint 2013 and Office Web Apps (OWA). Some customers have been running into issues when attempting to refresh data in a PowerPivot workbook on SharePoint 2013 using OWA server, and are seeing errors similar to the following...
on
31 Jan 2013
Blog Post:
PowerPivot for SharePoint - Scheduled Refresh to Oracle, IBMDB2, Teradata, SQL (en-US)
Tom S - MSFT
PowerPivot for SharePoint - Scheduled Refresh to Oracle, IBMDB2, SQL (en-US) Here is how to create a Scheduled Refresh to an Database that does not accept domain credentials in PowerPivot: Create 2 SSS IDs: 1. PowerPivotDataRefresh a. Create a SSS application using Group leaving application...
on
21 Dec 2012