Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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?

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

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
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.