Forum Discussion
Sarahdb425
Microsoft Employee
Microsoft EmployeeIs there a "general" data type?
Hello, I'm uploading data from excel into power query, and several of the columns have mixed data types. For example, numbers and text. In excel this data type is classified as "general", but I'm not...
Hi Sarahdb425 ,
You have the any data type (ABC123).
However, you should use this column as text.
See this reference:
Sarahdb425Microsoft Employee
Microsoft EmployeeThank you. I see that "Any" data type is an option if I select "transform data" but not "load". What is the difference here?
camargos88
Community Champion
Community Champion
If you select Any, after you load the data, it will convert to text.
You only have Any using Power Query (when PQ does not know which data type should use to convert to).