none
Update Power Pivot table with only new rows

    Question

  • Is there any way in Power Pivot, to only update a table with new and/or changed rows?

    Say I have a table with millions on rows, every day some new rows are added. Is there a way to only append the new rows, instead of downloading EVERY row each time I use Refresh?

    Wednesday, September 11, 2013 9:17 AM

Answers

  • No, there is no way to do this in PowerPivot in Excel.

    If you have a tabular instance of Analysis Services you could upgrade your model to that and design a load process to do incremental processing.

    Or if you have Sharepoint 2010/2013 with PowerPivot services you could upload your model there and set it do automatic refreshes overnight. (so it will still do a full load, but you don't have to sit there waiting for it)


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

    Wednesday, September 11, 2013 9:24 PM

All replies

  • No, there is no way to do this in PowerPivot in Excel.

    If you have a tabular instance of Analysis Services you could upgrade your model to that and design a load process to do incremental processing.

    Or if you have Sharepoint 2010/2013 with PowerPivot services you could upload your model there and set it do automatic refreshes overnight. (so it will still do a full load, but you don't have to sit there waiting for it)


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

    Wednesday, September 11, 2013 9:24 PM
  • No, there is no way to do this in PowerPivot in Excel.

    If you have a tabular instance of Analysis Services you could upgrade your model to that and design a load process to do incremental processing.

    Or if you have Sharepoint 2010/2013 with PowerPivot services you could upload your model there and set it do automatic refreshes overnight. (so it will still do a full load, but you don't have to sit there waiting for it)


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

    Hi Darran

    Thanks

    Could you elaborate on this: 

    If you have a tabular instance of Analysis Services you could upgrade your model to that and design a load process to do incremental processing.

    Friday, September 13, 2013 7:40 AM
  • No, there is no way to do this in PowerPivot in Excel.

    If you have a tabular instance of Analysis Services you could upgrade your model to that and design a load process to do incremental processing.

    Or if you have Sharepoint 2010/2013 with PowerPivot services you could upload your model there and set it do automatic refreshes overnight. (so it will still do a full load, but you don't have to sit there waiting for it)


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

    Darren,

    Please check out this thread: http://social.technet.microsoft.com/Forums/en-US/a2e22d61-7c32-43f2-900e-d9d6325fa26d/needed-more-answerers

    Thanks!


    Ed Price, SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Wednesday, September 25, 2013 12:42 AM