PowerPivot – "Invalid internet address" and "Failure creating file" errors using SharePoint workbook as data source

You may receive the following error when trying to access a SharePoint workbook as a data source using PowerPivot:     Failed to connecto to the server. Reason: Invalid internet address.   This error happens when accessing a data source in SharePoint using a URL. It is caused by a limitation of the data provider…


Excel Services – Large Workbook Error

You may receive one of the following errors when attempting to view an Excel workbook in SharePoint depending on your version of SharePoint:     “This workbook is larger than the maximum workbook size allowed to be opened in the browser.”     “Couldn’t Open the Workbook. Wow, That’s a big workbook. Unfortunately, we can’t…

5

Excel Services – Using a SharePoint List as a data source

Update: You can consume a SharePoint Online list in Excel Online and On Premise if you call the ListData.svc: Excel Online – Consuming SharePoint Listshttp://blogs.technet.com/b/office_online_support_blog/archive/2014/12/17/excel-online-consuming-sharepoint-lists.aspx Excel Services – Consuming a SharePoint List using the ListData.svchttp://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2015/07/28/excel-services-consuming-a-sharepoint-list-using-the-listdata-svc.aspx Since Excel Services inception (SharePoint 2007) users have been attempting to consume a SharePoint List in Excel Services.  Unfortunately this is…


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…


Upsizing PowerPivot 2013 Workbooks to SSAS for Knowledge Workers

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 administrator. This post assumes…

2

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


Error attempting to create new PowerPivot Gallery Document from PowerPivot gallery

With SharePoint 2010, you might run into an issue when attempting to create a new PowerPivot Gallery Document from PowerPivot gallery, like this:  If you encounter this issue, you may then see the following to errors: The reason for the error is that SharePoint is looking for the template .xlsx file in the wrong location….

9

PowerPivot for SharePoint Manual Data Refresh Failing

You might see a scenario where data refresh with PivotTables or slicers or Data > Refresh All Connections are not working, and you are seeing an error in the browser like this:  You may also find a corresponding error in the SharePoint logs like this one: “MossHost.TryGetWindowsIdentity: Current identity is ClaimsIdentity. We need to get a WindowsIdentity”…

3

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

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 but consider these scenarios:…