Data type Error

[TadepalliSaiKum]

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

[v-lili6-msft]

hi @TadepalliSaiKum 

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

[TadepalliSaiKum]

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

[hansei]

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

[VijayP · Accepted solution]

Table.TransformColumnTypes(Table6_Table,{{"Numbers", type any}})

Instead of "type text" as per above syntax use "type any" then problem should be solved