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

[freidus]

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 coming up with an error. All the errors seem to be related to putting numbers in a number format.

I am getting the error DataFormat.Error: We couldn't convert to Number.

However, they are all actually numbers. Here is one example:

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

I thought that it might be that the data type was set to whole number instead of decimal. However, I changed that, refreshed the preview, and it still comes out as an error.

Thanks so much.

Dani