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. 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