Power BI converting column into Scientific Notation

[anshpalash]

Hi,

I have an ID column which I am importing into Power BI through an excel file. Power BI is converting this column into scientific notation. How can I avoid that? All IDs are unique and need to be displayed as it is, no scientific notation.

Can somebody please offer any advise?

[v-jingzhang]

Hi @anshpalash 

I guess you have solved this problem right? Please accept a proper reply as solution or share your own solution. This will help more people find it. Thank you.

BR,

Jing

[v-jingzhang · Accepted solution]

Hi @anshpalash 

Your ID column is probably detected as Number type. You can open Power Query Editor and remove the "Changed Type" step below "Source" step in APPLIED STEPS pane. Then modify column types manually per your need. For this ID column, you can modify it to Text type if you only want to display the info in it later. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Anonymous]

In the options, deselect "Automatically detect column types on unstructured data sources.

--Nate