Forum Discussion
CSV data does not recognize column as numbers when contains negative numbers
When connecting to a CSV (generated with powershell) a column with numbers is recognized by Power BI web as numbers. Untill the column contains negative numbers then the column is recognized as stri...
Are you sure the negative numbers are actually marked with a true minus - character and not the dash – character? If even one of them is the dash character it will read as text. Also check to make sure there aren't space characters.
I have the same problem.
My file content (only single column):
Value
12989
-52890
993
-6101
Field "Value" was recognised as text.