Forum Discussion

Uzaring's avatar
Uzaring
Frequent Visitor
4 years ago
Solved

Problem with exponential data

Hi guys how are you?

 

I'm having some issues with a CSV that have some Id in exponential formats, like this: 1.15E+18

When I get this CSV with Power BI, the Query Editor interprets them well as a number but I'm losing characters and because of that many Ids are duplicated

In this example some of them are different but with this problem, the Ids are duplicated.

 

Do you know any way to upload them right? Any cast to do?

 

Thanks!

 

Need Help

1 Reply

  • DataInsights's avatar
    DataInsights
    Super User
    4 years ago

    Uzaring,

     

    Try this in a custom column in Power Query:

     

    Number.ToText(Number.From([Column1]))