Forum Discussion
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 ...
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 ?
Hi dprasetyo
Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.
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.