SharePoint24x7 It's all about SharePoint.

2Apr/140

Article – Installing SQL Server PowerPivot for SharePoint 2013

Self-service BI was introduced with SQL Server 2008 R2 with the introduction of PowerPivot. PowerPivot for Excel and PowerPivot for SharePoint became very popular among business users and it have them the opportunity to work with large amount of data within Excel with the ability of slicing and dicing data for detailed analysis.

This article guides you through the process of installing PowerPivot for SharePoint.

PowerPivot is not part of SharePoint or Excel and it is part of SQL Server. You need to have SQL Server Enterprise or Business Intelligence edition to use PowerPivot with Excel and SharePoint. You can install PowerPivot in either a SharePoint Server, Existing SQL Server or separate/ dedicated server. If you install PowerPivot on a SharePoint server, to use PowerPivot for SharePoint, you don’t have to install PowerPivot for SharePoint Add-In. If you install on an existing SQL Server or a dedicated server, you need to install PowerPivot for SharePoint Add-In in all the SharePoint Servers to get full feature set.

  • Mount SQL Server installation media. I used SQL Server 2012 with Service Pack 1 for my installation.
  • Double click setup.exe and select Installation from left navigation options. Select New SQL Server stand-alone installation or add features to an existing installation option.SQL Server Installation Center
  • Installation will execute set of Setup Support Rules and click OK if you don’t see any errors.Setup Support Rules
  • Installation will check for any available product updates and include if any. Click Next to install any updates available.Product UpdateProduct Update
  • Installation will execute another set of Setup Support Rules and click Next if there are no errors.
    Setup Support Rules
  • Select the option Perform a new installation of SQL Server 2012 and click Next.
    Installation Type
  • Enter the Product Key and click Next.
  • Accept the License Terms and click Next.
  • Select the option SQL Server PowerPivot for SharePoint and click Next.Setup Role
  • Click Next from the Feature Selection page.Feature Selection
  • Installation will execute set of Installation Rules. Click Next if there are no errors.Installation Rules
  • Accepts the default values in the Instance Configuration page and click Next.Instance Configuration
  • Click Next from the Disk Space Requirements page.
  • Provide a Service Account for the SQL Server Analysis Services in the Server Configuration page and click Next.Server Configuration
  • Click Add Current User from the Analysis Services Configuration page to grant administrative rights to the current user for Analysis Services.
    Analysis Services Configuration
  • Click Next from the Error Reporting page.
  • Installation will execute set of Installation Configuration Rules. Click Next if there are no errors.Installation Configuration Rules
  • Click Install from the Ready to Install page to start the installation.
  • Installation will take few minutes and Complete page will appear when installation completes. Click Close from the Complete page.

Next, I will guide you through the next steps of configuring SQL Server PowerPivot for SharePoint.

Posted by Joy