Ran the CSV through our deduper first. Loaded into Power BI without a single import warning. No complaints from the field reps.
Really appreciate you taking the time to write this, feedback like yours helps us prioritise the next refresh. Let us know if you'd like the file regenerated with extra columns next time.