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?

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)

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 f