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!
If you can upload an example of your data (copy paste from excel?) we can test some things for ourselves.
You could try to replace the comma in your file with a freshly typed comma? I think the other guy is right, and that your commas arent actually commas :P