none
PowerPivot and Analysis Services tabular instance in SharePoint RRS feed

  • Question

  • Hello,

    If I connect to the SQL Server 2012 SP1 Analysis Services tabular instance in SharePoint 2010 that houses all of the PowerPivot files that have been uploaded to our SharePoint environment, I only see a portion of the models  that exist. Why is this? What would cause a model on the tabular instance in SharePoint to disappear? Also, what does the “Sandbox” and “Process” preceding the model GUID mean?

    Thank you!

    Saturday, February 28, 2015 4:26 AM

Answers

  • if you upload an Excel workbook that contains a Power Pivot model to sharepoint nothing happen to SSAS at that point.
    Once someone accesses the workbook, the Power Pivot model is restored on the SSAS server as a separate/unique database and is suffixed with a GUID

    The DB will then be loaded into SSAS for some time until it is unloaded due to inactivity or memory pressure 
    if it was unloaded and is accessed again it will be restored again and a new GUID will be assigned

    In order to ensure that you can always connect to your model you need to use the URL of the Excel Workbook as the source of your e.g. Pivot Table and must not connect directly to SSAS

    hth,
    gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Monday, March 2, 2015 9:48 PM
    Answerer
  • Hi Haras,

    According to your description, you need to configure PowerPivot for SharePoint on your site, right?

    In this case, please use the following checklist to install these BI features in the same SharePoint farm: PowerPivot for SharePoint, Report Builder, and Power View.
    https://msdn.microsoft.com/en-us/library/hh231687.aspx?f=255&MSPPError=-2147217396
    Then publish a BISM Tabular Model Database connection on SharePoint site, please refer to the link below to see the details.
    http://fendy-huang.blogspot.in/2012/01/publish-bism-tabular-model-database.html

    Regards,


    Charlie Liao
    TechNet Community Support

    Wednesday, March 4, 2015 9:05 AM
    Moderator

All replies

  • if you upload an Excel workbook that contains a Power Pivot model to sharepoint nothing happen to SSAS at that point.
    Once someone accesses the workbook, the Power Pivot model is restored on the SSAS server as a separate/unique database and is suffixed with a GUID

    The DB will then be loaded into SSAS for some time until it is unloaded due to inactivity or memory pressure 
    if it was unloaded and is accessed again it will be restored again and a new GUID will be assigned

    In order to ensure that you can always connect to your model you need to use the URL of the Excel Workbook as the source of your e.g. Pivot Table and must not connect directly to SSAS

    hth,
    gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Monday, March 2, 2015 9:48 PM
    Answerer
  • Thank you! This is very helpful.  

    Would a scheduled refresh be considered "accessing" the model. For example, if I set the model to refresh daily, would this be the same as a regular user directly accessing the model every day?

    Thanks again!

    Monday, March 2, 2015 11:53 PM
  • to be honest, I dont know but I would expect it 

    however, as I said, you cannot control how long it will stay loaded in SSAS


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Tuesday, March 3, 2015 10:36 AM
    Answerer
  • Hi Haras,

    According to your description, you need to configure PowerPivot for SharePoint on your site, right?

    In this case, please use the following checklist to install these BI features in the same SharePoint farm: PowerPivot for SharePoint, Report Builder, and Power View.
    https://msdn.microsoft.com/en-us/library/hh231687.aspx?f=255&MSPPError=-2147217396
    Then publish a BISM Tabular Model Database connection on SharePoint site, please refer to the link below to see the details.
    http://fendy-huang.blogspot.in/2012/01/publish-bism-tabular-model-database.html

    Regards,


    Charlie Liao
    TechNet Community Support

    Wednesday, March 4, 2015 9:05 AM
    Moderator