Forum Discussion
Solved
Importing Exponents as text not Numbers
Hello. For some reason Power BI is importing values from one column (AnnualRevenue) as exponents (1.07E+11) instead of whole number values as they are in the excel (107,000,000,000). I've tried a...
I figured it out - for others references. The excel export I have put in the string NULL for empty values, thus the string was preventing the column from being classified as a number.
I figured it out - for others references. The excel export I have put in the string NULL for empty values, thus the string was preventing the column from being classified as a number.