Ran the CSV through our deduper first. Loaded into Power BI without a single import warning. Acceptable trade-off at this price.
Good to know what worked and what didn't, the points you raised are on the refresh checklist for the next pull. If you want the gaps fixed sooner than the next refresh, open a support ticket and we'll spin a one-off pull.