Welcome to the Galaxy...: Excel

Showing posts with label Excel. Show all posts

“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

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”

Reference articles:

http://blogs.msdn.com/b/analysisservices/archive/2012/12/21/refreshing-powerpivot-data-in-sharepoint-2013.aspx

http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2013/02/01/powerpivot-2013-refreshing-in-the-browser.aspx

http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2013/01/31/powerpivot-for-sharepoint-browser-refresh-fails-data-refresh-not-supported-in-office-web-apps.aspx

Unable to Refresh the Excel Connection in Excel Webaccess Webpart

If you are using an excel workbook with pivot in it, along with the Excess Webpart to display it. As you click on the Refresh all data connection.

It throws an error. The data connection uses windows authentication and user credentials could not be delegated. The following connection failed to refresh

Here is the resolution for this problem:

http://sharepointknowledgebase.blogspot.com/2012/05/data-refresh-failed.html

Change the path to a Data Feed in a PowerPivot workbook

Creating the datafeed files, published them to the document library and if you wanna change the server name / change the site name in the datafeeds then here is the solution:

http://www.powerpivotblog.nl/import-data-into-the-model-using-a-macro-in-excel-2013/

SharePoint 2013: Useful Links for Excel Services 2013

Here are some useful links for Excel Services 2013 for SharePoint 2013; if you find any other please update it!

Excel Services in SharePoint 2013

http://msdn.microsoft.com/en-us/library/jj164076(v=office.15).aspx

What's new in Excel Services for developers?

http://msdn.microsoft.com/en-us/library/jj163112(v=office.15).aspx

Excel Interactive View

http://msdn.microsoft.com/en-us/library/jj163261(v=office.15).aspx

Consuming OData feeds from Excel Services 2013 in PowerPivot

http://cwebbbi.wordpress.com/2012/07/24/consuming-odata-feeds-from-excel-services-2013-in-powerpivot/

http://msdn.microsoft.com/en-us/library/jj163874(v=office.15).aspx

Create and share external data connections by using Excel Services

http://technet.microsoft.com/en-us/library/jj733601(v=office.15).aspx

Business intelligence capabilities in Excel Services

http://technet.microsoft.com/en-us/library/jj219751(v=office.15).aspx