DataFormat. Error We couldn't convert to Number in Power BI Dataflow

[smjzahid]

I have a dataflow which has many transformation steps applied to it, It has been refreshing fine but since yesterday I am getting this error.

Error: DataFormat.Error: We couldn't convert to Number

I have gone through individual steps (by placing my mouse on each step) and then it takes to next step (its a very time consuming) but I have done it and have not found any error there. However when I try to perform (On Deman or Scheduled) refresh then above error gets thros and the entire refresh stops at that point. 

Is there a way to catch this error so that the refresh is successful in Power Query Online. How do we avoid such errors, as the dataflow do not point to specific line, Thanks in advance

[MrSujay]

Your source column data and PowerBI table-defined data type are different.
The solution is to find the column in the PowerBI table which storing INT value but the source column having text.

Then change the data type from text to decimal-based in Source OR  change the data type from Decimal/INT to Text Query-editor.

Check your step -