Report Portal

SharePoint 2010 and Excel 2013 Power Pivot

I've start seeing customers moving to or considering Office 2013 for self-service BI. Naturally, the end users would like to share their Excel 2013 self-service data models by deploying to SharePoint. Does SharePoint 2010 support this scenario? Unfortunately not. The user can upload Excel 2013 files and view the embedded reports. However, when he attempts to perform an interactive action (triggers all backend services involved in processing Power Pivot workbooks) he gets the dreaded error "Unable to refresh data for a data connection in the workbook".

Read more...

Tags: excel, sharepoint, tabular, refresh

 

2007-2015 VidasSoft Systems Inc.