02 January, 2013

We cannot locate a server to load the workbook Data Model.


Problem Description:
Assume that you use an Analysis Services source to create a PivotTable in Microsoft Excel 2013. You upload the Excel Workbook to a Microsoft SharePoint site.

When you try to either refresh the PivotTable or filter the data in the PivotTable, you receive the following error message:
We cannot locate a server to load the workbook Data Model.

Probable cause:
This issue occurs because the Analysis Services instance has not been configured in the Central Administration site.

Workaround/Resolution:
1.    To work around this issue, configure the Excel Services service application on the SharePoint server. To do this, follow these steps:
2.    In the Application Management section of the Central Administration home page, click Manage service applications.
3.    On the Manage Service Applications page, click the Excel Services service application that you want to configure.
4.    On the Manage Excel Services page, click Data Model.
5.    Click Add Server.
6.    In the Server Name box, type the name of the Analysis Services instance that you want to add.
7.    Click Ok.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues J

3 comments:

  1. Hi,

    Even though I add the PowerPivot Analysis server inn the data model, I am getting the same error "Could not locate a server to find the workbook datamodel"

    ReplyDelete
    Replies
    1. The best way to troubleshoot this error is by means of ULS logs. if you check those then you will definitely find something that will tell you the cause behind this-

      just for the reference: http://blogs.msdn.com/b/psssql/archive/2013/01/09/getting-a-power-view-report-within-excel-2013-to-work-with-sharepoint.aspx

      Delete
  2. Have you ever considered about adding a little bit more than just your articles?
    I mean, what you say is fundamental and all. Nevertheless
    imagine if you added some great visuals or video clips
    to give your posts more, "pop"! Your content is excellent but with pics and clips, this
    site could undeniably be one of the very best in its field.
    Wonderful blog!

    my web blog - sun.udsu.ru

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.