Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
@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