Forum Discussion

iannes's avatar
iannes
New Member
8 years ago

Scientific notation is being read as text

I need help, my data source has numbers like: 2.0356e+3 and 3.40685e-4

They are being read as text and changing the collum type in query editor is not working

How do i turn them into something Power BI can read as a numeric value?

 

Thanks

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi iannes,

     

    When you change the data type in the query editor what result do you get and error or your number convert to an integer?

     

    Regards,

    MFelix

    • iannes's avatar
      iannes
      New Member
      8 years ago

      Hello MFelix

       

      I solved the problem using Parse as Json, I managed to apply this to all columns , my  new question is if there is a way to automaticaly do this when I get new data in other tables.

       

      Thanks for the support!