Forum Discussion
Convert text to number from a folder data
Hello everyone, I'm a new guy here and already come with problems,
before you oversee this post I already know how to use the data format tools from modeling or query, and my data does not have the typical problem of some symbol avoiding power BI to convert to number
I export these files from a platform that has a predefined structure so I must make it work with query to avoid extra work in the future and also I have to get the data from a folder as I notice this problem does not show when I load the data as a .csv file
these are my steps:
- I load the data from a folder
- I delete the top 7 rows
- I promote the first row as a header
this is enough to create the problem as I understand this is a difficult to study I attach a file with 2 samples
remember if you want to see the problem you have to load the data from a folder
sample files
thank you very much for all
- v-sihou-msft8 years agoMicrosoft Employee