locked
initiate process of power pivot model in power pivot gallery RRS feed

  • Question

  • Hi EB

    Is there an open API\SDK for sharepoint's power pivot galleries allowing on demand processing of a power pivot model over there?
    idealy from a SSIS package?

    TIA!

    Rea
    Wednesday, July 8, 2015 2:07 PM

Answers

  • Yeah, that looks like it might work. I had not seen that they exposed the Refresh() method through the web service. The only things to consider would be what sort of authentication you need for your data sources and whether or not you can get a list of the connection names or if you have to hard code those.

    http://darren.gosbell.com - please mark correct answers

    • Marked as answer by reapeleg Wednesday, July 15, 2015 1:11 PM
    Wednesday, July 15, 2015 10:18 AM

All replies

  • The short answer is no. Microsoft does not provide any official API for programmatically triggering a PowerPivot refresh. You can setup scheduled refresh from within the gallery or (if your data connections meet certain criteria) a refresh can manually be triggered from the Excel Services UI. 

    Although the Powerpivot instance will respond to XMLA commands this is complicated by the fact that the Power Pivot service in Sharepoint can delete and re-deploy databases with a new ID when the workbook is updated and workbooks can be dynamically unloaded from memory if there is memory pressure or if the workbook has not been used recently.


    http://darren.gosbell.com - please mark correct answers

    • Proposed as answer by Michael Amadi Saturday, July 11, 2015 3:04 AM
    Saturday, July 11, 2015 1:23 AM
  • Darren

    Isnt using sharepoints 2013 excel services web service api duable as described here:

    The following code sample shows how to call the Refresh method using Excel Web Services.

    https://msdn.microsoft.com/en-us/library/office/ms497403.aspx

    Wednesday, July 15, 2015 9:08 AM
  • Yeah, that looks like it might work. I had not seen that they exposed the Refresh() method through the web service. The only things to consider would be what sort of authentication you need for your data sources and whether or not you can get a list of the connection names or if you have to hard code those.

    http://darren.gosbell.com - please mark correct answers

    • Marked as answer by reapeleg Wednesday, July 15, 2015 1:11 PM
    Wednesday, July 15, 2015 10:18 AM