I’m using PowerPivot (Excel 2013) to get data from an Oracle database.
Data is added daily to the Oracle database, and I need to get the new data into my PowerPivot.

Everything is working fine, I can connect to the database and get data to PowerPivot.

The problem is: every time I hit “Refresh” or “Refresh all” PowerPivot will download ALL the rows! I only need the new rows.

I use a simple SQL statement to get data:
Please Login or Register  to view this content.
My table has a unique incrementing key [ID] – so I only need data from Oracle that has a higher [ID] than any [ID] in my PowerPivot table.