Ran the CSV through our deduper first. Loaded into Power BI without a single import warning. Bought it for United Kingdom's 7bone locations segment specifically. Otherwise no complaints.
Thanks for the honest feedback, the points you raised are on the refresh checklist for the next pull. Open a ticket via the Support tab and we'll prioritise the columns you flagged for the next refresh.