Forum Discussion
Data formatting - Numbers are identified as text
Created a new file and CopyPasted the full query to the new file.
Everything works fine.
The only difference is that I did not create any measures and did not create any calculation tables in Tabular Editor.
Could it possibly be one of the reasons for a glitch?
Created a new file and CopyPasted the full query to the new file.
Everything works fine.
The only difference is that I did not create any measures and did not create any calculation tables in Tabular Editor.
Could it possibly be one of the reasons for a glitch?
- Pragati11
Super User
Hi Anonymous ,
No creating caluclations or measures won't affect the datatype of the column until it is chnaged explicitly.
Thanks,
Pragati
- negi007
Community Champion
Anonymous there are three places where you can change the data type (you can't change text to number if text has non-numeric characters)
1. source : Define the data type in the source data if possible
2. power query: change the data type here if you can't change it in the source
3. Power Bi desktop: finally, if it is not possible to change the data type in above two cases then change here. There are few data type which are only supported in the power bi desktop
- v-easonf-msft
Community Support
Hi , Anonymous
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution.For now, there is no content of description in the thread. If you still need help, please share more details to us.
Best Regards,
Community Support Team _ Eason
