Forum Discussion
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 couple different things:
1) Selecting the column in PBI and under modeling, selecting data type as whole number. I get an error that says it cannot automatically convert the values (also true for decimals).
2) Updating the type in the excel file to "number", saving the excel & refreshing the PBI.
3) Updating the values in the excel to currency, save & refresh.
Any advise? Thanks!
And I need this in order to do calculations on numbers that you can't do on strings.
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.
1 Reply
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.