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.
To build on what Anonymous stated. In your query editor use the replace text function to replace all hyphen/dash with a minus sign and then replace all spaces with no selection being made (to remove spaces). I generally do a transform as well with trim and clean in case there are other issues present.