Forum Discussion
Dataflow refresh fails due to conversion error
Goodmorning, I've been trying to refresh my dataflow but it keeps failing due to this error: Error: DataFormat.Error: We couldn't convert to Number. Request ID: d6e40ed0-e74a-820b-7fe0-aa3794b80...
jeffshieldsdev
Solution Sage
Solution SageWhat steps are in your "#"Transform File (2)"" query before all these other ones though? Anything casting of data types there?
Hi Jeff,
I finally found out why it didn't work. It was indeed in the helper querries. The only way i've now managed to prevent the dataflow from giving an error is by not automatically letting it determine the data type (based on the first 200 rows). One downside of this is that it doesn't combine the CSV files under proper column headers anymore, so i had to filter out the rows of the added csv files that contain headers.
To the best of my knowledge it is thus not possible to 'hard code' the data type in those automated steps, which is unfortunate. The workaround does work luckily 🙂