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
