PowerPivot workbook with a PowerPivot connection to a SharePoint list cannot be refreshed manually in the browser (Data > Refresh All Connections) using Windows authentication in SharePoint 2013

Issue As we all know 🙂 with SharePoint 2013, manual data refresh in the browser (Data > Refresh All Connections) for PowerPivot workbooks will refresh data all the way back from the original PowerPivot data source, which is specified in the PowerPivot workbook's PowerPivot connection. This functionality is different with SharePoint 2010, where manual data…

1