Question

9ballz on Sat, 30 Aug 2014 07:58:31


hey guys

I get this error when I open powerpivot documents in sharepoint.

"We cannot locate a server to load the workvbook Data Model."

after I've looked into the logs I came up with this:

Check Server Version (SQLSERVER2012\POWERPIVOT): Fail (Expected: >=11.0.2800.0, Actual: 11.0.2100.60).	 
--> Check Deployment Mode (SQLSERVER2012\POWERPIVOT): Pass.	 
Monitorable	Check Server Configuration (SQLSERVER2012\POWERPIVOT): Fail (Uninitialized, ConfigurationError, WrongVersion).	 
SSPM: Initialization failed on server SQLSERVER2012\POWERPIVOT: Microsoft.AnalysisServices.Streaming.ServerConfigurationException: Server SQLSERVER2012\POWERPIVOT failed configuration checks (Status = Uninitialized, ConfigurationError, WrongVersion).     at Microsoft.AnalysisServices.Streaming.OnPremise.Server.AssertServerConfiguration(Server amoServer, CancellationToken ctx)     at Microsoft.AnalysisServices.Streaming.OnPremise.Server.Initialize(Guid serviceId, CancellationToken ctx)     at Microsoft.AnalysisServices.Streaming.OnPremise.Tasks.InitializationTask.Run(CancellationToken ctx)	 

how can I update my analysis server version that doesn't affect anything else?

should I install a CU on my SQL or upgrade it?

thanks




Sponsored



Replies

Elvis Long on Wed, 03 Sep 2014 06:21:37


Hi 9ballz,

We will encounter this issue if the Excel  Services Application is not configured to use a Analysis Services sever in SharePoint mode.

To work around this issue, configure the Excel Services service application on the SharePoint server. To do this, follow these steps: 

  1. In the Application Management section of the Central Administration home page, click Manage service applications.
  2. On the Manage Service Applications page, click the Excel Services service application that you want to configure.
  3. On the Manage Excel Services page, click Data Model.
  4. Click Add Server.
  5. In the Server Name box, type the name of the Analysis Services instance that you want to add.
  6. Click OK.

Here is a KB article regarding this issue, please see:
http://support.microsoft.com/kb/2769345

For more detail information regarding troubleshoot this issue, please see the TechNet Wiki below:
http://social.technet.microsoft.com/wiki/contents/articles/3870.troubleshoot-powerpivot-data-refresh.aspx?Sort=MostUseful&PageIndex=1#Issue_Cannot_Locate_a_server_to_load_a_workbook

Regards,

A Bauman on Wed, 17 Dec 2014 20:12:23


We have workbooks which were successfully using a data model and are now failing.  I have edited and saved the data models in Excel Services, but the reports are still having issues.  I have also restarted analysis services.  Are there other suggestions?

SteveDStewart on Mon, 18 May 2015 17:01:59


Do an IISRESET on each server where Excel Services is online. You can use the following PowerShell command to get a list of servers:

get-spserviceinstance | where {$_.typename -like "*excel*" -and $_.status -eq "online"} | select server

I hope this helps,

Steve

A Bauman on Mon, 18 May 2015 17:26:54


Hi Steve, 

It was not an issue with the service instances, as we had only one instance running and multiple reports working, with just one failing.  To the best of what I have been able to determine since then, if you are connecting to a data connection in the file and then build a pivot table off of the first connection, it creates a data model just in the workbook.  The workbook then fails on the web.  The only resolution was to rebuild the files. Replacing connections did not work.