I have an Excel file that has a list of countries. Some of the countries the newer Excel Data Type feature recognized the data as a country. Power Query and thus Power BI do no read those cells and ...
Hi asjones ,
As far as I know, it doesn't seem to support this kind of data type recognition and conversion, for now.
If you would like to suggest feature improvements, you may vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best Regards,
Community Support Team _ Caitlyn