locked
Power Pivot - Beginner Question RRS feed

  • Question

  • Hello,

    Is it possible to work with Power pivot with SQL server 2008 (not R2...)

    Thanks,

    David

    Sunday, April 4, 2010 10:06 AM

Answers

  • PowerPivot is a free add-in for Microsoft Office 2010 that can be downloaded from http://powerpivot.com/.

    You can import data from many relational data sources into powerpivot workbook, including SQL Server 2005, SQL Server 2008 and others.

    You will only need SQL Server 2008 R2 and SharePoint 2010 if you want to publish your workbooks to Sharepoint, schedule data refresh, collaborate with other people in your organization. You don't need SQL Server 2008 R2 to start using PowerPivot.


    Tatyana Yakushev [PredixionSoftware.com]
    Monday, February 14, 2011 6:56 PM

All replies

  • David,

    Hi.   The PowerPivot product is a feature that is part of the SQL 2008 R2 release. Therefore, it would not be included if you were installing the base install of SQL 2008 and the requirement for a SharePoint Farm also is SQL 2008 R2 Enterprise Edition. 

    You can review the architecture and requirements here:

    Visual views:
    http://blogs.msdn.com/blogfiles/powerpivot/WindowsLiveWriter/PowerPivotComponentArchitecture_95C/image14.png
    http://blogs.msdn.com/blogfiles/powerpivot/WindowsLiveWriter/PowerPivotComponentArchitecture_95C/image20.png 

    Doc view: http://blogs.msdn.com/powerpivot/

    A snippet from there:

    "Analysis Services Client Libraries   Enable client applications to communicate with the PowerPivot Web service. Clients must use the SQL Server 2008 R2 version of the client libraries to support PowerPivot connections."

    However, there are pieces that will work in SQL 2008 & SQL 2005, the relational database.  The Database Engine, for the SharePoint farm, not the PowerPivot application server, can be SQL 2005 SP2, or SP3 or SQL 2008 CU4, although it is still recommended to be SQL 2008 R2 for optimal usage/performance. 

    Hope this helps.
    Thanks for participating in the Forums.
    ~Meghann [MSFT]

    Monday, April 5, 2010 3:00 PM
  • David,

    I also should have pointed you to the PowerPivotFAQ site here that also answers this question. Since it does seem like an easy question but gets complicated depending on which pieces you are looking to implement.  The PointPivotFAQ site is a great resource site to go to and usually directs you to some great material, in this case to the powerpivot.com prereqs and also powerpivotgeek:

    http://powerpivotfaq.com/Lists/TGPPF/DispForm.aspx?ID=121&Source=http%3A%2F%2Fpowerpivotfaq%2Ecom%2FLists%2FTGPPF%2FAllItems%2Easpx

    Their answer was the following:

    No. You only need the add-in and the Excel 2010. Information about integration with SharePoint (PowerPivot for SharePoint) you can see here: http://powerpivotgeek.com/2010/01/29/what-database-support-is-needed/ See the full prerequisites list here: http://powerpivot.com/download.aspx.

    ~Meghann [MSFT]

    Monday, April 5, 2010 4:48 PM
  • The only thing that matters is the add-in and that it should have Excel 2010. I am not sure this component is based on Analysis Services 2008 in which case SQL Server 2008 R2 is needed.

     

    I am sort of curious is what is this modeler and where do you find some information.

    Way too much under the hood!!

     


    mysorian
    Saturday, June 5, 2010 12:02 AM
  • Hi David

     Power Pivot 2010 is add-in which is worked only with SQL Server 2008 R2 that is why it will not comes with SQL Server Earlier package.

    There are some great feature included in this like DAX (Data Analysis Expression),table.MsoNormalTable { line-height: 115%; font-size: 11pt; font-family


    Abhishek Parihar BI Consultant
    Tuesday, January 11, 2011 6:28 AM
  • PowerPivot is a free add-in for Microsoft Office 2010 that can be downloaded from http://powerpivot.com/.

    You can import data from many relational data sources into powerpivot workbook, including SQL Server 2005, SQL Server 2008 and others.

    You will only need SQL Server 2008 R2 and SharePoint 2010 if you want to publish your workbooks to Sharepoint, schedule data refresh, collaborate with other people in your organization. You don't need SQL Server 2008 R2 to start using PowerPivot.


    Tatyana Yakushev [PredixionSoftware.com]
    Monday, February 14, 2011 6:56 PM