Forum Discussion
Solved
csv data type
Dear All, I downloaded a CSV file from a finance web site. I have downloaded their CSV files before and use them in Power Query, Excel and so on so I know they are usually fine. The first row...
I have see this happen sometimes when you try to convert it to a whole number and it wont let you. For me, it was because some of the fields really were NOT NUMBERS. Double check your data to make sure that:
1. There really are only numbers in the column
2. If your header repeats itself in the file, make sure you remove that header by filtering it out.
Can you try changing the types in the queries editor window? There should already be a change type step, which maybe incorrectly changing the types to text.