Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.