Synchronizing Dataverse for Teams tables from another system is very complex. There is no ability to import from a flat file so we have to load with Power Automate flow.
Loading from Excel we have to add a complex "read the Excel row, query the database for the record, if it exists then edit, if not then add new. This could all be fixed with an upsert action.
I'm told that the SDK already has the upsert function present, we just need to see it as an option in the connector.