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...
Have you actually explicitly set the column to a number datatype in the query editor before loading, or are you just allowing Power BI to auto-detect data types?
Power BI Service automaticaly recognized data types.
I'm using PowerBI Service (Web) to create auto updated Dashboard. I am using CSV's on the Onedrive.
When CSV is changed datasets/reports/dashboards are automatically refreshed.
In case Power BI Desktop everything works correctly with the same data.