Tried three vendors before this. Loaded into Power BI without a single import warning. Bought it for a India retail (online & offline) market-sizing project. Otherwise no complaints.
Thanks for the detailed review, the points you raised are on the refresh checklist for the next pull. Drop a note via Help → Contact Support and we'll line up a fresh export for you.