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 both for your suggestions. However, I have tried what you have suggested with no luck.
Even when I change the type to text, which I understand should be able to read anything, it doesn't work with these specific cells.
The delimiter that I am using is commas. When I view the file in Excel, there is no issue with these numbers and they are dealt with correctly.
I should note that in the columns where I am having the issue, it is only the numbers with decimal points that are not being read correctly.
MarcelBeug
Community Champion
Community ChampionCan you share the code part where the numbers are comverted, so we can see what Locale code you are using?
Does your input have decimal commas or decimal points?
Or maybe a mix of commas and points?