Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SQL Server 2012 Powerview Installation

Answered SQL Server 2012 Powerview Installation

  • Thursday, February 07, 2013 11:52 AM
     
     
    Sign In to Vote
    0
    Please provide me a complete pre-requisite to have a powerview in my machine.. like which operating system, sharepoint if required, SQl Server 2012... etc etc.. I am really got confused with the installation procedure for Powerview. Please provide me an end to end guide to get ready to create a powerview application from installation perspective.

    Kunal Dedhia


    • Edited by MyDeas Thursday, February 07, 2013 11:52 AM
    •  
     

All Replies

  • Thursday, February 07, 2013 12:36 PM
     
     Answered
    Sign In to Vote
    0

    Hi Kunal,

    Please follow the steps based on the number:

    (1) refer to this website for installing Sharepoint:

    http://technet.microsoft.com/en-us/library/cc262957.aspx

    or (1) Refer to for references about how to install in multiserver (Three Tier Farm)

    http://technet.microsoft.com/en-us/library/ee805948.aspx

    (2) Create a Site of Sharepoint

    http://technet.microsoft.com/en-us/library/cc263094.aspx

    (3a) Install Analysis Services sharepoint mode to enable PowerPivot Features

    http://technet.microsoft.com/en-us/library/jj218792.aspx

    (3b) COnfigure PowerPivot

    http://technet.microsoft.com/en-us/library/jj682085.aspx

    (4) Install Reporting Services Sharepoint and Reporting Services Integration Sharepoint Add-ins to enable PowerView Features

    http://technet.microsoft.com/en-us/library/jj219068.aspx

    (Handy References)

    http://channel9.msdn.com/posts/SQLShorts-Installing-and-Configuring-PowerPivot-Power-View-and-the-BI-Semantic-Model--BISM-

    http://saeedamir.blogspot.com.au/2012/12/install-reporting-services-in.html

    Note: some link sometimes show "Content Not Found" just refresh the page, it should show up the content.

    read carefully and I suggest try to install on one machine and see how it goes... and next you can try to install to multi thier computer.

    Please try in development environment if you really want to seperate the machine, I suggest to create virtual environment for multi tier environment.

    Good Luck,

    WidodoTM.

     
  • Friday, February 08, 2013 2:31 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Kunal,

    Please follow the steps below to finish the Powerview installation.

    1. SharePoint Server 2010 with Service Pack 1 (SP1)
    2. SQL Server 2012 Database Engine
    3. SQL Server 2012 Reporting Services and Reporting Services Add-in
    4. SQL Server 2012 PowerPivot for SharePoint

    After you install these features, you will be able to do the following.

    • Access the PowerPivot workbooks that you created in PowerPivot for Excel from SharePoint sites.
    • Build interactive Power View reports based on PowerPivot workbooks in SharePoint.
    • Create Report Builder reports when you launch Report Builder in SharePoint.

    For the detail information about Deployment Checklist: Reporting Services, Power View, and PowerPivot for SharePoint, please see:
    http://msdn.microsoft.com/en-us/library/hh231687.aspx

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

    If you have any feedback on our support, please click here.

    Charlie Liao
    TechNet Community Support