Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
Try this in a custom column in Power Query:
Number.ToText(Number.From([Column1]))
Proud to be a Super User!
Try this in a custom column in Power Query:
Number.ToText(Number.From([Column1]))
Proud to be a Super User!