Forum Discussion
nrowey
Helper I
Helper IError 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.
nroweyHelper I
Helper II 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}})
Tutu_in_YYC
Super User
Super UserLooks 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.