SharePoint 2013 OnPrem | Excel Service refresh for PowerPivot Linked Table RRS feed

  • Question

  • Hi Guys,

    We have SharePoint 2013 On Premises environment configured with Excel Services running like a charm. Excel Reports render in browser, they refresh data connections in browser as well. We also use Power Pivot capabilities and have Power Pivot Data Refresh as well working according to schedule.

    However there is one excel file which uses power pivot and also the Linked Tables in Power Pivot. This report does not refresh the connections in browser or through Power Pivot scheduler. We've checked that the connections are all fine. Every other report does refresh of connections on browser while this report alone which has Linked Tables throws error when refresh of connections in browser is done.

    An error occurred while working on the Data Model in the workbook. Please try again.

    We were unable to refresh one or more data connections in this workbook. 

    I would like to know if there is anything different that needs to be done when Linked Tables are involved or is this a product limitation?

    Wednesday, October 7, 2015 8:23 PM


All replies