Forum Discussion
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 Whole Number. Row number with 4,5 is shwing as error as the data type is not getting matched. Plese help me in this issue
Table.TransformColumnTypes(Table6_Table,{{"Numbers", type any}})
Instead of "type text" as per above syntax use "type any" then problem should be solved
4 Replies
When PowerBI reads a source, it attempts to match data to a type. It is often wrong. Do you see an entry like
Table.TransformColumnTypes(#"Source", {"Column", Int64.Type})Change Int64.Type to
type text
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
