Forum Discussion
DataFormat.Error: We couldn't convert to Number.
Hi I am a real beginner in Power BI and I would greatly appreciate some help. I am importing a large number of rows from 8 csv files (about 3m rows). A large number of these rows is comin...
Thank you so much for your help.
The code is as follows:
= Table.TransformColumnTypes(#"Changed Type1", {{"Actual_Receipts", type number}}, "en-GB")The numbers in this particular column are all negative (preceded with a - ) or are 0. Some of the numbers do not have decimal points (eg -145101) and some do (eg -2146457.58). It seems that the numbers with decimals are the ones resulting in errors.
As far as I can tell, all the numbers with decimals all have decimal points (none with decimal commas).
Thanks again so much!
The only things I can think of:
1. The decimal point is some other character than a normal period (which has decimal unicode 46), and/or:
2. There are additional unprintable characters in your text. You can remove these by using Transform - Format - Clean.