Dataflow Incremental Refresh - Insert Records Only

[MattBossert]

I have a dataflow which queries a transactional SQL table to pull current counts of emails assigned to various teams.  This SQL table only contains current counts and does not contain any historical records, thus it does not contain any datetime column.  There's no way to query this table to tell me how many emails were assigned to each team yesterday, just the current count at the moment in time the query is executed.

I am trying to use incremental refresh on my dataflow to insert the results of this SQL query into my PowerBi table and not update or delete any exisiting records.  I'd like the table in this dataflow to be a historical record of how many emails were assigned to each team, each day.

My SQL query returns:

[Date the query was run], 

[Team Name],

[Email Count]

My Incremental refresh settings:

I believe the issue is in the "Refresh rows from the past 1 Day" as each day the query is run, it's deleting the previous day's results.  I cannot set this value to 0, so I'm curious if there's some other way to accomplish this "Insert Only" incremental refresh?