Forum Discussion
DataFormat.Error: We couldn't convert to Number.
Thank you all for your help.
I have, to some extent, managed to work around the issue by using Excel files, instead of CSV files, as the source.
Still don't understand what was wrong with the CSV files.
I am going to copy an excerpt of my data (from the original csv, opened with a text editor), to see if anyone can pick up formating issues:
03/07/2009,7,2009,1400000,6,30/07/2009,Jul-09,0,100,Out_Period,94,80,-370.18,-370.18,Advance,348.83,0,2146457.58,1395.32,-2146457.58,100,
The item with the issues is the "-2146457.58". Please excuse the random extract, but the data are confidential.
No issues with your excerpt.
If the previous tips didn't help, then maybe you can share a file (Excel or pbix) with only that single value (in a query) that is having the issue.