Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to stop scientific notation

I am loading Excel data into Power BI. This data has ID columns which have large numbers. Excel converts these to scientific notation by default. I can convert them into regular numbers by formatting them as number columns. But then when I load then into Power BI, they get loaded in scientific notation. When I try to convert the numbers into text, like they should be, they go back into scientific notation. Is there a way around this?

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago

    I just experimented with this. I left the numbers in scientific notation in Excel. I imported into Power BI. Power BI displayed them in scientific notation but the underlying data was their actual numbers. Converting to text displayed them as their full number values.

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi aabi01,

     

    You may try function below in power query and check if the column value can be changed to text format. 

     

    =Number.ToText(Number.From())

    Regards,

    Jimmy Tao