Thursday, September 12, 2013

“External Data Refresh Failed An error occurred during an attempt to establish a connection to the external data source . The following connections failed to refresh:” error in SharePoint 2013 PowerPivot data refresh

While practicing with SharePoint Excel Services and Power Pivot office web apps, when refreshing the data I got an error saying that
“External Data Refresh Failed……”

By checking the error found a solution from TechNet blog. When using Office web apps in SharePoint 2013, Excel files will be viewed in WOPI (Web Application Open Interface) and edited through Office Web Apps. When SharePoint farm is configured to use excel apps, Excel services and power pivot features will depend on the Excel web app server configurations.

Excel web app runs in SharePoint View ode and Office web server view mode. In URL, if see “xlviewer.aspx” it is running on SharePoint Mode. If URL Contains “WopiFrame.aspx”, excel web app is running in “Office Web Apps Server view Mode”. If we use OWA Server view mode, to view the workbooks, Some BI features like Excel Web Access Web part, Refresh ODataConnections web part, View and interact PowerPivot view/data models...
We have to apply suppression setting on the farm to work with slicers and refresh data. So that we can edit the document in browser with Office Web Apps. We can suppress the Office webapps using following PowerShell command,

New-SPWOPISuppressionSetting –Extension “XLSX” -Action “view” 

Share this