PowerPivot Workbooks as a Data Source

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 be aware,…

6

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…

0

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

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


What is PowerPivot for SharePoint? Part 2.

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, that file gets chunked up…


PowerPivot for SharePoint 2010 & SQL 2012 – Refresh in browser fails due to multiple "Process" Data Models in Analysis Services.

    When opening a workbook after a Schedule Data Refresh, the workbook does not open in Excel Services:     This is because after a Scheduled Data Refresh, the “Refresh data when opening the file” is checked.  This is by design, because after a Scheduled Data Refresh, the workbook’s Data Model is updated with…


Excel Services Fix – "The workbook cannot be opened".

When opening an Excel workbook (.xlsx) in the browser the error “The workbook cannot be opened” is thrown: This is caused by the account running Excel Services not having proper permissions to the Content Database.  When you upload an Excel workbook to a SharePoint library, the workbook is stored as blobs in the Content Database. …


Tools and Techniques: Troubleshooting Kerberos in Excel Services and PowerPivot for SharePoint

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\Control\Lsa\Kerberos\Parameters Registry Value: LogLevel Value Type: REG_DWORD Value Data: 1…


Excel Services Data Refresh Failed. Kerberos.dll bug (Server 2008 pre R2).

I have had several cases where a customer will have Kerberos properly configured but refresh in the browser fails. In the UI, the error will appear. “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.” IMPORTANT: I have also seen the…