Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

    Advertisements
  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

Configure PowerPivot Site Collection in SharePoint 2013

Posted by Paul on December 7, 2015


In this article we can explore.

Install SQL Server BI Edition

There are different editions of SQL Server. We need to choose the Business Intelligence one.

image

You can install this on the same machine where SharePoint & SQL Server already exists.

Following is the Download link if you have MSDN Subscription. It is around 3GB.

image

Choose the Installation > New SQL Server option

image

Pass through the upcoming wizard.

image

image

PowerPivot Configuration Tool

Now you can run the PowerPivot for SharePoint 2013 Configuration. This tool will configure the required service applications, services & site templates for PowerPivot.

You should be logged in as Farm Administrator to the machine.

image

You will get the tool loaded like below.

image

In the appearing page enter the core details:

1. Farm Account

2. Power Pivot Instance Name

image

Click Validate & then run button to complete the operations.

Central Administration

Go to Central Administration & Create a new site collection. You should be able to choose the PowerPivot template as shown below.

image

Enter the User Name & Click Ok to create the site collection.

Once the site collection is created you can open it in Browser.

SharePoint

In the new site collection you can open the library named PowerPivot Gallery. This is the core library used for BI.

image

You can configure following advanced content types for the library.

image

Testing

If you already have Analysis Server & Cube created you can create a new Report Data Source object to create a Report within the browser.

image

You can enter the details shown below.

image

You can choose the Farm Account & Use as Windows credential option.

Once the connection is successful you will see the new item as shown below.

image

You can try clicking on the item & use Report Builder within the browser itself.

image

This confirms our PowerPivot installation for SharePoint 2013.

References

https://msdn.microsoft.com/en-us/library/jj820150(v=sql.110).aspx

Summary

In this article we have explored how to configure PowerPivot Site Collection in SharePoint 2013.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s