Jonathan on 04 Jul 2016 13:47:44
When I import data from an Excel spreadsheet with a column containing both numbers and text (i.e. an ID column where some IDs have letters), the numeric IDs get displayed in scientific notation. This is a major problem as people need to be able to read these IDs.
- Comments (5)
RE: Numbers in Text Fields Showing Scientific Notation
Hey Charles, these Excel sheets are automatically exported. Does this mean I'll have to go into the sheet every day and manually add quotes before all the IDs with large numbers? Couldn't there be an option to turn this on/off?
RE: Numbers in Text Fields Showing Scientific Notation
To clarify, this problem is not visible in Excel - the numbers are all displaying correctly there, it's only on import into Power BI that they turn into scientific notation, which renders them useless.
RE: Numbers in Text Fields Showing Scientific Notation
This is by design.
To have Excel NOT do this please append a quote ' before these ids.
RE: Numbers in Text Fields Showing Scientific Notation
Hey Chuck,
Try out these values:
VT12069028 - Fine
26 - Fine
73 - Fine
680310381602 - Displayed as 6.803E+11
617627990719 - Displayed as 6.176E+11
541500120505 - Displayed as 5.415E+11
RE: Numbers in Text Fields Showing Scientific Notation
Hello Jonathan,
I just tried this and not seeing what you are describing...using the values below.
That said guessing this is not a bug and you might be able to convert values back to text.
That said if you supply an example of the values you are importing i can verifying there isn't any data loss in the conversion from text to numbers
ID Amount Qty
123n 12 2
n456 13 1