Problem with exponential data

[Uzaring]

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!

[DataInsights · Accepted solution]

@Uzaring,

Try this in a custom column in Power Query:

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