locked
Do users need PowerPivot installed on their machine RRS feed

  • Question

  • We are wanting to move to PowerPivot.

    My question is can i use PowerPiovt as a tool between the SQL server and the Client, and not have to load PowerPivot onto all the client machines.

    Our reason is to take advantage of the data crunching ability of Powerpivot.

    In this case 90% of our end users are not going to be making any BI solutions with PowerPivot, we will be doing this at our end.

    Example:

    Excel in our dept is at its maximum capicity, so stage 1 of a new reporting tool build, is to start taking these large workbooks and push them through PowerPivot this will reduce the size of the workbook, then supply the finished product to users.

    Once we have stabalised the key reports, we can move to Stage 2.

    Any advise would be helpful

    thanks


    David

    Tuesday, October 16, 2012 6:55 PM

Answers

  • Hi David,

    If you have configured PowerPivot for SharePoint in your environment, the users not need to install PowerPivot for Excel add-in. We can directly use PowerPivot data to create SSRS report. Here is an article for your reference, please see:
    Create a Reporting Services Report Using PowerPivot Data: http://technet.microsoft.com/en-us/library/gg413489.aspx

    If the users use Excel Services and PowerPivot data to create business report, you need to install PowerPivot for Excel add-in. For more information about installing PowerPivot for Excel, please see:
    PowerPivot for Excel Installation: http://technet.microsoft.com/en-us/library/ee210599.aspx

    Regards,


    Bin Long

    TechNet Community Support

    • Marked as answer by Elvis Long Wednesday, October 24, 2012 6:34 AM
    Wednesday, October 17, 2012 10:44 AM

All replies

  • You can create PowerPivot reports from the machines which have PP for excel installed and then publish them in SharePoint 2010 & above. Now, other users can just access these reports from SharePoint as a web page (they dont need to have PP installed on their machines if they are just accessing it in SharePoint) and use the slicers to filter the data. However, they will not be able to edit the PP reports unless they have excel installed.

    You can also use tools like SSRS, PowerView (and in reality, any front end tool that can read analysis services) to use PowerPivot as a source if it is published in SharePoint, and then create reports out of it.


    Cheers,
    Jason
    P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

    Some Random Thoughts

    Follow me on Twitter

    Tuesday, October 16, 2012 7:13 PM
    Answerer
  • Thanks for this,

    What about the following

    I create a excel workbook using Powerpivot, save the workbook (this reduces the size of the workbook) and then deploy it to a computer that does not have powepivot in excel.

    This user does not need to use it as a BI tool side, do they get the benifit of a reduced size workbook?


    David

    Tuesday, October 16, 2012 7:27 PM
  • Hi David,

    If you have configured PowerPivot for SharePoint in your environment, the users not need to install PowerPivot for Excel add-in. We can directly use PowerPivot data to create SSRS report. Here is an article for your reference, please see:
    Create a Reporting Services Report Using PowerPivot Data: http://technet.microsoft.com/en-us/library/gg413489.aspx

    If the users use Excel Services and PowerPivot data to create business report, you need to install PowerPivot for Excel add-in. For more information about installing PowerPivot for Excel, please see:
    PowerPivot for Excel Installation: http://technet.microsoft.com/en-us/library/ee210599.aspx

    Regards,


    Bin Long

    TechNet Community Support

    • Marked as answer by Elvis Long Wednesday, October 24, 2012 6:34 AM
    Wednesday, October 17, 2012 10:44 AM