Configure PowerPivot for SharePoint 2013 – Part 5

In this post I will create a basic Power View Report by creating a connecting from PowerPivot Add-On. I will create a Table, chart and map.

I Opened Excel 2013 and clicked on Insert Power View button to enable PowerPivot and Power View Add-on.

You must click Enable

Wait for it to Finish

Here you go. You must be able to see PowerPivot and Power View Ribbons. Click On Manage

Now click on Get External Connection. We will use a connection that we created in last post.

Click existing Connections

Click Browse for More

Browse to your SharePoint site where you have your data connection uploaded.

Select your data connection

It will be visible. Click Open

Click to Test

Click Design to Design Query

You will see Dimension and Measurement section on the left. Expand the required Column and right click to add it to result.

It will not show any result. Yes it will not because we do not have any measurement.

Lets click on … Icon next to Adventure Works to filter the measurements by cubes.

Let’s Select Sales Summary.

Use Right Click or Drag the column to the right.

The results will show up now.

Click Ok when done.

PowerPivot will now load data in Excel. I have tested with 2.5 million rows.

It will be visible in Excel PowerPivot section.

Let’s Add a column with Formula to calculate Tax Percentage.

Now Click on Power View from Insert Ribbon and Change the title.

Use the Fields section to show fields in content section. Use Checkbox or Drag.

Click in an empty area and select the fields again to add a second section.

Select the 2nd Area which will enable Power View Ribbon for you.

Select the option you like.

You can also change the chart if you like.

Add a second Power View and select the fields. Select the area and select Map to see a live map of results.

Save the excel sheet to SharePoint library.

Before you browse the excel sheet in browser you must give access of PowerPivot cubes to users.


Let’s go to the library.

Check out the Map.

End of Part 5. In the next Post I will use SQL Server Reporting Services to display data.


Leave a Reply

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

You are commenting using your 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