Importing Exponents as text not Numbers

[SarWal]

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.

[SarWal · Accepted solution]

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.