Convert text to number from a folder data

[soyrbto]

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:

1. I load the data from a folder
2. I delete the top 7 rows
3. 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

thank you very much for all

[v-haibl-msft]

@soyrbto

I’ve got response from the Product Team.

Works as designed. The editor never shows more than 1000 rows, and may show less when the data is large. Further, the editor only uses ~200 rows for type inference. Lets assume that the data is small enough so that we will get exactly that many rows. The editor looks at the first 200 rows and sees that all of the values can be converted to numbers. So it inserts a step to do so. Then, the editor runs the query against the first 1000 rows and all the conversions work. But in the 4000th row, there's a value in the column which can't be converted -- so that row produces an error value. The user has two options: either edit the formula so that the value is not converted to a number any more or fix the input data (which may be in error). The user may also do more complicated things by writing more formulas by hand.

Best Regards,
Herbert

[soyrbto]

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:

1. I load the data from a folder
2. I delete the top 7 rows
3. 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-msft]

@soyrbto

I reproduced your issue. 

We have reported this issue internally.

Regards,