Ran the CSV through our deduper first. Loaded into Power BI without a single import warning. Bought it for our buy hsbc locations for united kingdom ( sales team's United Kingdom pipeline. Money well spent.
Appreciate you flagging what worked, always good to hear from buyers using the file for real outreach.