Microsoft Query SQL not deleting old data

Hi everyone,

I have an inventory watchlist report built using microsoft query to our sql database.

When I refresh the data query, the products duplicate and old data is saved.


For example product (123) has 0 on hand and 20 on work orders as of (6/21/2022)

When I refresh the connection today, a new row is added for the same product (123) but with updated inventory - ex: 10 on hand 10 on work orders.


That leaves me with duplicate rows in excel, which confuses my lookup functions in other sheets.

Does anyone know how to remove old data and update the excel table to new data without duplicating a product in a new row?

I have a column in the Excel table called CreatedTime. When I had to do this I look for the latest CreatedTime in the Excel table and only add records greater than the latest CreatedTime.