Ability to ensure success of API pushed data without duplicates

I'm seeing that there are occasional hiccups that I would expect from any cloud source so my app retries upload the same rows to a table in Power BI upon failure. However, sometimes that retry creates duplicate rows because the previous try actually succeeded despite the HTTP call returning an error or lost network connectivity.

I think you should implement some way of making sure we can reliably ensure we have completed pushing a set of data without creating duplicates. Maybe you just give us the ability to query the model with DAX so we can see if a row exists or not after an upload error. Or maybe there's some other way of getting a status message for a prior request.