Tried three vendors before this. Loaded into Power BI without a single import warning. Will be the default vendor for us now.
Appreciate you flagging what worked, we'll keep tightening the column coverage in the next refresh. Let us know if you'd like the file regenerated with extra columns next time.