Dataflow issue - "We couldn't convert to number"

[Anonymous]

Hi everyone

Myself and my team are moving all the queries from the Power BI desktop to dataflows. We are doing this by copying the M-Code on the desktop and pasting to the dataflows.

We have found some dataflows would crash even though the Power BI desktop dataset wouldn't. The most common error we have is: "Error: We couldn't convert to Number..."

- Is there any difference between the power BI desktop query transformation and Dataflow query transformation?

- The failed refresh attemp .csv only shows what table within the whole dataflow has the error. Is there any way we can check what specific column is having the error?

Thank you for your help

David. 

[az38 · Accepted solution]

@Anonymous 

it could be a localization issue. I often met the same in Desktop - solution is to replace delimiter, for example, comma "," to "." or vice versa before convertation to number data type

Desktop is using your local machine regional settings, dataflow -  server side's settings