Forum Discussion

nrowey's avatar
nrowey
Helper I
4 years ago
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: ...
Dataflow
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    4 years ago

    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.

aybarsacar's avatar
aybarsacar
Frequent Visitor
3 years ago

Hi all,

Running into same error. How were you able to debug which column is creating the error.

My data source has around 100 attributes and I wasn't able to get a descriptive error log from Power BI that would direct me to the source.

How would I know which column creates the type casting error from the error log?

Cheers,