Scientific Number in Text Field

knagarlmet That's strange because the column header says ABC which is text but the values are formatted as numbers, italicized and right justified. This is how it should look as a text column:

Hi Greg_Deckler. Thanks. Yes, glad it's not just me confused by this. Any advice or things I should try?

Hi knagarlmet 

It's werid that the value is shown in scientific notation even though the data type is text. What's even werider is that the numbers appear italicized and right-aligned just like how numbers are typically displayed in the query editor. I have created a dummy table in sql containing a long string of numbers and set the data type to number. Power Query displays it correctly. Have you tried explicitly changing the data type yourself as text instead of relying on the default schema from the database? Otherwise, try these custom columns

Text.From([Column])


Text.From([Column]) & ""

Thankyou, Greg_Deckler, danextian, for your response.

Hi knagarlmet,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

From my understanding, the issue arises because Power BI’s Query Editor automatically detects long numeric strings and may incorrectly interpret them as numbers, displaying them in scientific notation even when the original data is text. To retain the complete value without scientific notation and to ensure proper functionality for table joins, kindly follow the steps outlined below which may help resolve the issue:

1. In the Power Query Editor, right-click on your column and select Change Type > Text.
2. If the value still appears in scientific notation, add a new custom column using the following formula:
   = Text.FromBinary(Text.ToBinary(Text.From([code], "en-US")))
   

   This approach compels Power BI to treat the value as plain text and prevents numeric formatting.

3. Remove the original column if it is no longer required, and then load the corrected data.

   Additionally, please navigate to File > Options > Data Load, and uncheck the option "Detect column types automatically" to avoid this issue in future.
   
   We hope that the information provided will assist in resolving the issue. Should you have any further questions, please feel free to reach out to the Microsoft Fabric Community.

   Thank you.

Hi knagarlmet,

We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

Hi knagarlmet,

We want to check if the information we gave helped fix your problem.If you need more support, please reach out to the Microsoft Fabric community.

Thank you.

Hi knagarlmet,

Thank you for your update and for sharing your insights and approach towards resolving the issue. Kindly continue to utilize the Fabric Community for any further assistance with your queries.

Thank you.