Dataflow refresh fails due to conversion error

Hi Jeff,

Yes I tried adjusting the helper queries, but not with succes. If in the first screen you get after you click on "combine files" you select "Based on first 200 rows" your data type detection already determines it is a number column, and uses that to make the helper querries. However my number column has text somewhere after row 200 and thus it fails. The only thing that worked for me is to use "Do not detect datatypes" as shown in picture two. But then for every file it adds to your table you get a row simmilar to row 1 in the second picture. Not ideal, but easy to filter out.

If you still think it should be possible i might try it again, but with validating my flow and refreshing it, it is very time consuming to do this trial and error wise.

Kind regards,

Luca