Forum Discussion
Solved
Data type Error
I am enetering the following data and power bi is showing some error 1.1001 2.1002 3.1003 4.AP29 5.AP30 The above data is in one column and then by default power bi is taking the data type as W...
Table.TransformColumnTypes(Table6_Table,{{"Numbers", type any}})
Instead of "type text" as per above syntax use "type any" then problem should be solved
When PowerBI reads a source, it attempts to match data to a type automatically.
You could disable it in File>OPTIONS>Data Load, and uncheck "Automatically detect column types and headers for unstructured sources".
also, you could change the datatype in edit queries.
https://carldesouza.com/automatically-detect-data-types-in-power-bi/
Regards,
Lin
Ok.After stopping the auto-detection which data type should i select for that column. Should I go with "Text" data. Ig that is the case then what about the numeric data? will it be auttomatically converted into text data type
