DataFormat.Error: We couldn't convert to Number.

[A9kurs]

Hi everyone,

I have one data which has coumn Items in this i column i have a data which has Item no , some of items are numeric only , some of them are combination of alpha numeric, after loading in power bi i converted them into text but it still gives error , i also tried = Table.TransformColumnTypes(#"Added Custom",{{"Item", Any.Type}}). nothing is working i am getting error (DataFormat.Error: We couldn't convert to Number.
Details:
AM220)

DataFormat.Error: We couldn't convert to Number.
Details:
2029526-X

DataFormat.Error: We couldn't convert to Number.
Details:
B0020315

Thanks for help 

[v-yangliu-msft]

Hi  @A9kurs ,

This is the related document, you can view this content:

Solved: DataFormat.Error: We couldn't convert to Number - ... - Microsoft Power BI Community

Solved: DataFormat.Error: We couldn't convert to Number - ... - Microsoft Power BI Community

Solved: Error - DataFormat.Error: We couldn't convert to N... - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[A9kurs]

I dont have rights to send send pbix file. give error when i paste pbix file . The file type (.pbix) is not supported.

[Ahmedx]

Share sample pbix file to help you.