How to stop scientific notation

[Anonymous]

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?

[v-yuta-msft]

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

[Greg_Deckler]

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.