Forum Discussion
Solved
Error DataFormat.Error: We couldn't convert to Number trying to add a data flow.
Trying to create a new data flow keep getting this error: "DataFormat.Error: We couldn't convert to Number. 24200C. RootActivityId = 0be9b5d6-87b4-42e6-a4d2-30d2dd930d48.Param1 = DataFormat.Error: ...
Looks like the only column left that is being converted to number is Postingamount. For testing, try converting Postingamount to Text too. If the dataflow runs, then my guess is a text has accidentally ended up in the Postingamount column.
I changed below excluding the dates and one Numeric still same error..
Table.TransformColumnTypes(#"Expanded table column", {{"Source.Name", type text}, {"companyid", type text}, {"accountingdate", type datetime}, {"accountnumber", type text}, {"control", type text}, {"control2", type text}, {"controltype", type text}, {"detaildescription", type text}, {"journalid", type text}, {"postingamount", type number}, {"postingsequence", type text}, {"refer", type text}, {"schedulenumber", type text}, {"statcount", Int64.Type}, {"rowlastupdated", type datetime}, {"cora_acct_code", type text}})
Looks like the only column left that is being converted to number is Postingamount. For testing, try converting Postingamount to Text too. If the dataflow runs, then my guess is a text has accidentally ended up in the Postingamount column.