Forum Discussion
OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number...
Hi Sai_Akash ,
Difficult to say exactly without more information, but the first thing I'd do is go to the query that is failing with this error, find any columns that are converted to a number type (Decimal or Whole Number/Integer) during the transformation, select them one by one and go to the Home tab > Keep Rows (dropdown) > Keep Errors. This should hopefully help you identify rows where a conversion error has occurred.
Pete
Hi Sai,
The error you posted implies that you still have a row with a non-numerical value in it.
Try adding a custom column like this, which you can then filter on to identify offending rows:
if try Value.Is(Number.From([ID]), type number) otherwise false then "Numeric" else [ID]Pete
Hi Sai_Akash,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thanks for reaching out to the Microsoft Fabric Community forum.
Hi Sai_Akash,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.
Hi Sai_Akash,
We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If my answer resolved your query, please mark it as "Accept Answer" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!