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.