We have recently set up a SharePoint 2013 farm with SSRS and PowerPivot (both SQL 2012 SP1) integrated. Everything seems to be working with one exception. If you select the "Manage Data Refresh" button in a PowerPivot Gallery or the "Manage PowerPivot Data Refresh" link from the context menu in a document library you immediately get an error message:
Sorry, something went wrong
An unexpected error has occurred
Go back to site
Expanding "Technical details" yields a correlation ID and date-time.
Finding that correlation ID in the SharePoint ULS logs yields the following error message:
The PowerPivot service application is invalid or does not exist.
This appears to be coming from an attempt to access page "/_layouts/15/PowerPivot/ViewDataRefreshHistory.aspx" and includes the following stack trace:
System.Exception: The PowerPivot service application is invalid or does not exist. at
Microsoft.AnalysisServices.SPAddin.DataRefresh.DataRefreshUtils.GetDefaultProxy(String url) at
Microsoft.AnalysisServices.SPAddin.DataRefresh.DataRefreshHistory.LoadDataRefreshHistoryByID(String url) at
System.EventHandler.Invoke(Object sender, EventArgs e) at
Microsoft.AnalysisServices.SPAddin.GeminiPageBase.OnLoad(EventArgs e) at
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
The interesting thing is, interactive data refresh (selecting "Refresh all data connections" from the Data menu when the PowerPivot sheet is displayed in the browser) works just fine.
I've verified everything that I can think of related to PowerPivot in the SharePoint farm and all seems to be in order. I've been unsuccessful finding any information about this on the Internet and any assistance would be greatly appreciated!
Can you Check whether your webapplication has access to the powerpivot service applications.
Go to the service connections of the webapplication and select the powerpivot service application if it is unselected.
Check whether u have installed Server Server Service pack and
data providers are installed.
It still errors accors
check with our datarefresh account
whether data refresh account has access to the cube?
I also would suggest you to check if you create a PowerPivot Service Application or assign a PowerPivot Service Application to a Web Application. Here is the document for yur reference, please see:
Generally, a service application is created automatically if you used the PowerPivot Configuration Tool to configure the server. You can also use the PowerPivot Configuration Tool to repair an existing installation of PowerPivot for SharePoint. For more information, please see:
TechNet Community Support