The resource object with key ‘DataRefresh_Warning_DataSources’ was not found

UPDATE: 8/16/17 – This issue should be fully resolved with the below patches!! If you have not already installed the following patches on your PowerPivot for SharePoint Analysis Services instance and/or the MSI DO NOT PROCEED WITH THE INSTALLATION! SQL 2012 SP3 CU6 – Resolved (see below) SQL 2012 SP3 CU7 – Resolved (see below) SQL 2014 SP1…


Run the "PowerPivot Configuration Tool" after Upgrading the Analysis Services POWERPIVOT Instance.

After applying an update to the Analysis Services Server running PowerPivot, you also need to upgrade the sppowerpivot.msi on the SharePoint Server running PowerPivot and re-run the PowerPivot Configuration Tool.  These two (SQL and SharePoint) need to have matching builds.  For example, if you apply the Cumulative update package 7 for SQL Server 2012 Service Pack 1 to…


Data Refresh using DSN in Excel Services and PowerPivot for SharePoint 2013

Over the last few months, we have seen a few more instances of people using data sources that require a DSN connection to retrieve data for PowerPivot and Excel workbooks. Normally, if you are just using these data connections inside the client, you just refer to the DSN as a data source and all is…


With PowerPivot 2012 for SharePoint 2013, thumbnails may not always generate properly in the PowerPivot gallery for non-PowerPivot workbooks (red X)

Issue Consider this scenario: You have a SharePoint 2013 environment with the PowerPivot 2012 add-in for SharePoint installed. You have non-PowerPivot workbooks in your PowerPivot gallery, and you have successfully set up scheduled data refreshes for those non-PowerPivot workbooks. When you upload the non-PowerPivot workbooks to the PowerPivot gallery, thumbnails for those workbooks are generated successfully….


BISM icons not present in SharePoint 2013 Library

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 are…


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

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 functionality is different with SharePoint 2010, where manual data…


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…


Power View Sheets not rendering in the browser

If you are using a Power View Sheet and it is not rendering in the browser (see below screenshot): You will want to verify if you are using Office Web Apps Server 2013 (WopiFrame.aspx) to render the workbook by examining the URL: URL Example: http://servername/sites/BICenter/_layouts/15/WopiFrame.aspx?sourcedoc=%2Fsites%2FBICenter%2FTest%20PowerPivot%20Gallery%2FPower%2Exlsx&action=view If you are indeed using the WopiFrame.aspx, you will want…


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;EN-US;2825647 See this blog for detail…


Excel Services 2010 & 2013 – Kerberos Configuration

Configuring Kerberos for Excel Services is a two step process; Information Gathering and Configuration. Step 1: Information Gathering: 1. Account running “Excel Services Application Web Service Application”: In this example: ECSSvc. Central Administration > Security > Configure service accounts 2.  Account running “Claims to Windows Token Service”:  In this example: Local System. Central Administration >…