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

Question

Hi everyone,&nbsp;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&nbsp;= Table.TransformColumnTypes(#"Added Custom",{{"Item", Any.Type}}). nothing is working i am getting error (DataFormat.Error: We couldn't convert to Number.Details:AM220)&nbsp;DataFormat.Error: We couldn't convert to Number.Details:2029526-X&nbsp;DataFormat.Error: We couldn't convert to Number.Details:B0020315&nbsp;&nbsp;Thanks for help&nbsp;&nbsp;

ahmedx · Answer

Share sample pbix file to help you.

a9kurs · Answer

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

anonymous · Answer

Hi&nbsp; A9kurs&nbsp;,
&nbsp;
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
&nbsp;
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.

Forum Discussion

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

3 Replies

Related content

[DataFormat.Error]

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

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

DataFormat.Error when converting numbers with non-breaking spaces

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