Ran the CSV through our deduper first. Loaded into Power BI without a single import warning. Genuinely useful.