PowerPivot Incremental Data only on Refresh

[ptanalyst]

Hi,

I am working on an 80M row data set (3 year order line details for a B2B) and need to be able to refresh the model weekly with any new information, as opposed to refreshing the entire table which can take up to a couple of days depending on what else is happening on the server.

Is there any way of accomplishing this in Excel 2013 Powerpivot?

Thanks

 

[unclesomebody]

Given that no one has replied to this and I can't find a positive answer on google I think the answer is no. I have found plenty of search results indicating it isn't possible but I just can't believe that is really the case. I've got a data set with several tables each with 5+ million rows and I can't be hitting the server everytime I want to do a refresh.

Time to go back to trying to learn Tableau...