Deploying PowerPivot and PowerView in SP2013

Search for Power Pivot Configuration Tool on the server under the start menu and open it. Click Configure the “Configure or Repair PowerPivot for SharePoint”


Let the PowerPivot Configuration Tool run.


Click validate in the bottom right to see if everything tests out alright.

Next make sure to that each farm solution is deployed. In Central Admin, navigate to System Settings -> Manage Farm Solutions


Make sure the farm solution (WSP file) named PowerPivotWebApplicationSolution is deployed to the web application that you would like.


Next navigate to Site Collection Features and activate two features PowerPivot Feature Integration for Site Collections and PowerView Integration Feature.


Now go on and create Power Pivot reports or Power View reports based on BI Semantic model data connections!

Tagged with: , ,
Posted in Business Intelligence, Power View, PowerPivot, SharePoint, SSAS
3 comments on “Deploying PowerPivot and PowerView in SP2013
  1. Adolfo says:

    Hey there would you mind letting me know which webhost
    you’re working with? I’ve loaded your blog in 3 different browsers and I must say
    this blog loads a lot faster then most. Can you recommend a
    good web hosting provider at a honest price? Thank you, I appreciate it!

    • andybdixon says:

      Hi Adolfo,

      Welcome to the blog. SharePoint Rhapsody is hosted on wordpress which I would recommend. In addition, we are using the responsive theme on the blog which allows the blog to appear consistent across browsers and media devices (tablets, phones, etc). Let me know if you have any other questions.



  2. says:

    Heya i am for the first time here. I found this board
    and I find It really useful & it helped me out much.
    I am hoping to present something again and help others such as you aided me.

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

%d bloggers like this: