none
Is "PowerPivot for Sharepoint" necessary to refresh PowerPivot data using Excel Services?

    Question

  • Is "PowerPivot for SharePoint" necessary to refresh PowerPivot data using Excel Services? We've published a workbook to SharePoint, and clicking on the refresh button results in error "Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator. The following connections failed to refresh: PowerPivot Data".



    • Edited by anodragon Monday, July 29, 2013 6:15 PM
    Monday, July 29, 2013 3:16 PM

Answers

  • Hi Anodragon,

    To refresh a PowerPivot in SharePoint, you need a special library type called a PowerPivot Gallery.  This becomes available after installing the PowerPivot for SharePoint add-in.

    Do you have PowerPivot Gallery library types available to you on your SharePoint instance?

    Excel Services is the feature that renders the workbook on a browser.  




    Javier Guillen
    http://javierguillen.wordpress.com/

    Wednesday, September 25, 2013 1:59 PM
    Answerer

All replies