none
Saivng last run data in Power Pivot

    Question

  • Hi All,

    I am using cube as a source for my power pivot reports.

    Suppose I create a report and I run it on a monthly basis using power pivot technology.

    My first run suppose is on 1<sup>st</sup> Jan 2014 and if I will run the report on 1<sup>st</sup> Feb 2014 again, it will overwrite the previous data which I got on 1<sup>st</sup> Jan 2014.

    Is there any option to “Do not refresh automatically” or save the previous state of data without overwriting it.

    Thanks

    Syed Faiz


    SFH

    Wednesday, February 19, 2014 7:46 PM

Answers

  • no, you can only do full loads in Power Pivot

    means for February you would need to load January+February from your cube in order to get the full set of data

    -gerhard


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

    Thursday, February 20, 2014 2:28 PM
    Answerer
  • Hi Syed,

    Generally, we focus on historical data BI analysis in most cases. If you want to review previous historical data in your report(such as PivotTable, Power View and so on), we should consider implementing Time Intelligence/Filter/Slicer for your scenario.

    Regards,


    Elvis Long
    TechNet Community Support

    Tuesday, February 25, 2014 9:47 AM
    Moderator

All replies

  • no, you can only do full loads in Power Pivot

    means for February you would need to load January+February from your cube in order to get the full set of data

    -gerhard


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

    Thursday, February 20, 2014 2:28 PM
    Answerer
  • Hi Syed,

    Generally, we focus on historical data BI analysis in most cases. If you want to review previous historical data in your report(such as PivotTable, Power View and so on), we should consider implementing Time Intelligence/Filter/Slicer for your scenario.

    Regards,


    Elvis Long
    TechNet Community Support

    Tuesday, February 25, 2014 9:47 AM
    Moderator