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>