Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

0
asjones

Power Query Does not Read Excel Cells formatted with Data Types added

Submitted by Helper V on ‎12-20-2022 11:46 AM

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 instead give an error. I tried this in both Power Query in Power BI and Power Query in Excel. 

Below is an example of the Excel cell set with a Data Type that can not be read (has the extra symbol) and one that can be read. The next screen shot is what Power Query shows.

Is this a known issue with Power Query? Is it on the radar to be fixed anytime soon?

asjones_0-1671565382507.png



asjones_1-1671565395056.png

 

Status: Delivered
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎12-21-2022 11:34 PM

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

Idea Statuses