Forum Discussion
Helper IIPower BI converting column into Scientific Notation
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?
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.
3 Replies
v-jingzhangCommunity Support
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.- 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
