Error returned: OLE DB or ODBC error: [DataFormat.Error] We couldnt convert to Number

[OJ]

Hi All,

may I kindly ask you for your help?

I am getting this error message:

"Failed to save modifications to the server. Error returned: OLE DB or ODBC error: [DataFormat.Error] We couldnt convert to Number"

There are only few columns containing only text and then 1 column with date and 1 column with forecast number. There are around 10 exactly same excel files differing only with forecasts numbers as the time goes. I have changed last 2 columns also to text (so everything is text) but it didn't help. Any suggestions how to fix this?

Thank you in advance!

[TrevorC]

I had this same error. It was due to the combination of date formatting and regional settings. ie 11/30/2021 vs 30/11/2021.

I am troubleshooting a join that uses fuzzy logic. It is giving me an error when I publish it to the service. When I do I get the error "Unable to load language information for LocaleId 4105." I copied my queries into another file and changed the regional settings to see if that would address the issue. I didn't think that the interpretation of dates would be an issue but it is. In Canada we allow all possible date formats (insert eyeroll) and changing the locale to the US locks it down and led to this error.

[v-piga-msft · Accepted solution]

Hi @OJ,

What is your data source and when do you get this error?

In addition, you could have a reference of the similar thread from the links below.

https://community.powerbi.com/t5/Desktop/DataFormat-error-We-couldnt-convert-to-Number/td-p/61492

https://community.powerbi.com/t5/Desktop/Error-DataFormat-Error-We-couldn-t-convert-to-Number-Detail...

Best  Regards,

Cherry

[OJ]

Hi Cherry,

Problem was with unpivot function... solved now after reading suggested discussions. Thank you very much! 🙂

[Anonymous]

Hi 

Could you share how you were able to solve this problem? Also having the same problem when pivoting my data

Thanks 🙂

[Anonymous]

I managed to solve the same problem Removing Errors before unpivoting. I changed all columns data types, then removed errors before unpitvoting and it worked