Forum Discussion

dprasetyo's avatar
dprasetyo
Frequent Visitor
8 months ago
Solved

Text Field was Read as Scientific Number

Hi, I have a problem in showing pure text data type in Table kind of visualisation. In my ID column, I have several rows consist of multiple IDs (that's why I set it to text data type in csv and in ...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    8 months ago

    Hi dprasetyo 

    Is the scientific notation appearing in Power Query Editor, in the data view, or only in a report visual?

    After changing the column to Text, did you apply the change in Power Query and click Close & Apply?

    Is there any step in Power Query (for example Changed Type or Added Custom Column) that might be converting the value back to a number?

    can you share the error screenshot or sample CSV data file ?

danextian's avatar
danextian
Super User
8 months ago

Hi dprasetyo 

Can you please  the original text strings as in  the data source so we can check this ourselves?

dprasetyo's avatar
dprasetyo
Frequent Visitor
8 months ago

thanks for the suggestion. I've changed the column in my csv into text data type and refresh my power query transformation, but it still showing scientific notation.

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    8 months ago

    Hi dprasetyo 

    Is the scientific notation appearing in Power Query Editor, in the data view, or only in a report visual?

    After changing the column to Text, did you apply the change in Power Query and click Close & Apply?

    Is there any step in Power Query (for example Changed Type or Added Custom Column) that might be converting the value back to a number?

    can you share the error screenshot or sample CSV data file ?

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      7 months ago

      Hi dprasetyo 

      Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

      • v-aatheeque's avatar
        v-aatheeque
        Community Support
        7 months ago

        Hi dprasetyo 

        Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.