none
How to get PowerPivot on the web RRS feed

  • Question

  • Hi there,

    How can I upload a PowerPivot sheet on the web - as a website? I don't want to use Sharepoint.

     

    regards

    Anders

    Tuesday, September 27, 2011 2:16 PM

Answers

All replies

  • Hi,

    I need to know if it is possible to publish a PowerPivot workbook not in a PowerPivot site and PowerPivot gallery but as a web application maintaning the interaction with slicers.

    Any suggests to me, please? Many thanks

    Tuesday, September 27, 2011 3:48 PM
  • Hi,

    from what I know it's not simple (rather it's impossible) to use PowerPivot on the web outside of SharePoint.


    Best Regards. Please Mark Answered, If my solution solves your problem.
    Tuesday, September 27, 2011 3:55 PM
  • Hi,

    But it can be done :)

     

    If you havn't seen it, then check this out.

    http://www.powerpivotpro.com/2011/09/mr-excel-makes-his-hostedpowerpivot-site-public/

    http://mrexcel.hostedpowerpivot.com

    Username: MRXL@pivotstream.com
    Password: P0werP!vot

    Wednesday, September 28, 2011 7:19 AM
  • To be clear ... PowerPivotPro uses Sharepoint.  The difference is that they do all the SharePoint work for you (for a price of course).
    bob mick
    Wednesday, September 28, 2011 6:08 PM
  • Hi Pacorca,

    I find we can achieve this, you can refe to this: http://www.powerpivotpro.com/2011/09/mr-excel-makes-his-hostedpowerpivot-site-public/

     

     


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, September 29, 2011 10:56 AM
    Moderator
  • Hi Challen, I've already seen this link. Do you have any further details on how PowerPivot has been hosted?

    Thanks

    Thursday, September 29, 2011 11:17 AM
  • Hi bob mick,

    I'm referring to HostedPowerPivot. The article on PowerPivotPro are just talking about the possibility to get PowerPivot on the web... 

    Thursday, September 29, 2011 12:23 PM
  • Hi exAHSacto,
    My choice of words were poor.  To clarify my clarification :-) ...

    The original question was about how to put powerpivot apps on the web outside of sharepoint. The hosted solution you referenced uses services from PivotStream and PivotStream uses "PowerPivot for Sharepoint".


    bob mick
    Thursday, September 29, 2011 12:41 PM
  • Hi ExAHSacto,

    You can click the File menu, then you will see Save & Send, on the right pane, click Save to Web, you can save to the web site, however, it is just a excel file after saving it on the web, by default, you can view the pivottable or pivotchart but you cannot have the interactive operation to PowerPivot on the web site. 

    Thanks,
    Challen Fu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.


    Friday, September 30, 2011 7:02 AM
    Moderator
  • Hi,

    no problem bob mick.

    Challen Fu --> I'm aware of the Save to Web function, but as you said that doesn't help me. I want to know how HostedPowerPivot.com do it.. I see PowerPivot as an excelent function to have on your website.

     

    thanks again!

    Monday, October 3, 2011 7:19 AM
  • Hi Challen,

    I'm agree with exAHSacto. The HostedPowePivot solution seems more attactive than publish a workbook inside the PowerPivot gallery, and more integrated with SharePoint. A such solution should be spreaded (in a free manner) or included in the SharePoint server licence. It is very important to do not lose any interactions with slicers/filters.

    Thanks

    Tuesday, October 4, 2011 8:58 AM
  • Hi Anders,

    I can confirm: to publish a PowerPivot workbook to the web you need to use SharePoint.

    The reason for this is that PowerPivot needs some kind of Excel environment. So there are two options:
    - Excel client: this is PowerPivot for Excel add-in
    - Or Excel Services which is in SharePoint
    You can get an overview here
     http://technet.microsoft.com/en-us/library/ee210692.aspx

    Based on bellow blog I think that HostedPowePivot is also using SharePoint, it is just invisible from the outside.
     http://www.powerpivotpro.com/2011/05/hostedpowerpivot-com-from-pivotstream-rackspace/


    Not sure if it helps but to give a full picture I would like to mention Tabular Mode which will come in Denali.
    A Tabular Mode instance is a regular (meaning not SharePoint integrated) instance of Analysis Services which uses the VertiPaq engine.
    You could use the APIs like ADOMD.NET to access data and build your own application.
     http://msdn.microsoft.com/en-us/library/hh230973(v=SQL.110).aspx


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Thanks,
    Orsi
    Microsoft Online Community Support

    Wednesday, October 5, 2011 2:46 PM
  • Orsi,

    Thanks for the useful info.  The Tabular mode sounds interesting and I was not aware of it. (Busy doing PowerPivot apps :-) and have not had time to look at Denali). 

    BTW: We looked at Powerpivot for Sharepoint to host PPv apps, but it required a serious upgrade for our infrastructure (and we do not have the bandwidth for it now).  We also looked at hosting (PivotStream/hostedpowerpivot) and decided that we needed to focus on making the apps first - we have a lot of other things going on.


    bob mick
    Wednesday, October 5, 2011 2:57 PM
  • Hi Orsolya, before the release of Denali what we do?

    PowerPivot for SharePoint allows to publish the PowerPivot workbooks created with Excel 2010 and PowerPivot for Excel, but it isn't represented the better integrated solution for SharePoint. It is necessary to open the workbook published to interact with it. The HostedPowePivot seems more attractive ... waiting the Denali release.

    Bye

    Wednesday, October 5, 2011 3:26 PM
  • Hi,

    Unfortunately I don’t have any alternative. The web facing PowerPivot product has SharePoint as requirement.
    And as it seems HostedPowePivot offers a service that provides a hosting solution so you don’t have to deal with SharePoint yourself.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
     
    Thanks,
    Orsi
    Microsoft Online Community Support

     

     

    Thursday, October 6, 2011 2:26 PM
  • This blog post might be of interest:

    http://blog.gobansaor.com/2011/09/21/exposing-an-excel-powerpivot-model-as-a-web-service/

    Friday, October 7, 2011 3:35 AM
  • Thanks, but it seems a bit hard to implement.

    Bye

    Friday, October 7, 2011 8:48 AM
  • Hi Bob,

     

    Please do not hesitate to contact us if we can be of assistance to you in building your apps and/or hosting them on our HostedPowerPivot.com service.  We would be happy to assist and get the models ready and available to your business users.

     

    Regards,

     

    Jeff Elderton

    CEO, Pivotstream

    330.460.0090 x1

    Friday, November 11, 2011 7:58 PM
  • Finnaly got a test system running Denali:  loaded my apps data tables, build relationships ... and still learning.  Orsi, you menioned building my own (clinet) app.  Does any standard Microsoft client access SQL 2012 Tabular databases?  Performance Point would be handy.

    Bob


    bob mick
    • Edited by bob mick Monday, November 14, 2011 8:03 AM
    Sunday, November 13, 2011 11:39 AM
  • Check this out:

    http://plexhosted.com/business-intelligence/overview.html



    Best Regards, Michael Starostin | www.plexhosted.com

    Saturday, April 13, 2013 1:54 AM