SharePoint24x7 It's all about SharePoint.

7May/140

Article – Associating PowerPivot SQL Server Analysis Services server instance with Excel Services

Posted by Joy

In my previous article, I demonstrated how to install SQL Server PowerPivot for SharePoint. After installing PowerPivot for SharePoint, you need to configure it before start using it. One of the configurations is associating PowerPivot SQL Server Analysis Services server instance with the Excel Services.

This article guides you through the process of associating PowerPivot SQL Server Analysis Services server instance with Excel Services.

  • Open SharePoint 2013 Central Administration web site. Select the option Manage service applications from the Application Management section.Application Management
  • Click Excel Services service application name to navigate to Manage Excel Services Application page.Manage service applications
  • Select Data Model Settings option from the Manage Excel Services Application page to navigate to Excel Services Application data Model Settings page.Manage Excel Services
  • Click Add Server from Excel Services Application Data Model Settings page to associate PowerPivot SQL Server Analysis Services instance with Excel Services.Excel Services Data Model Settings
  • Enter the name of the server in the Server Name field including PowerPivot SQL Server Analysis Services instance name and click OK.Add Server
  • Now you can see PowerPivot SQL Server Analysis Services server is associated with Excel Services.
    Add Server

Now you can move on to other configuration steps Smile