Setting up a Power View Reports in SharePoint

 

 

Creating a Power View Report Report library

 

Activate the Power the PowerPivot Integration Feature

SharePoint Central Administration -> Manage farm features and clicking on Active

 

 

Ensure the Power View Integration Feature and PowerPivot Feature integration for Site Collection features is activated

 

 

Add a Power Pivot Library Name

Type Power in the Search bar

 

 

Add a PowerPivot Gallery document library. Click on “add an app” link

Give the Library a Name

You will notice New Document option is disabled. In order to enable it, follow the next step: 

 

Go to Library Setting > Advanced Settings and enable “Allow Management of Content Types”

You will notice “New Document” link is enabled but it allows to create PowerPivot Gallery document

To be able to create Power View Reports, you need to add the following site Content Types.

Add Content Types

  • BI Semantic Model Connection
  • Report Data Source

 

Now you will notice that it allows you to create a “PowerPivot Gallery Document”, “BI Semantic Model Connection” and “Report Data Source” under New Document menu as shown

 

Leave Reply

Hey, so you decided to leave a comment! That’s great. Just fill in the required fields and hit submit. Note that your comment will need to be reviewed before it’s published Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>