Solved: Re: Need help on Apply query Chnages

coolshib · ‎10-02-2020

Hello Everyone,

I am getting the following errors while refreshing my data in power bi

1) OLE DB or ODBC error: [DateFormat.Error] We could not convert Number

2) OLE DB or ODBC error: Exeption from HRESULT: 0x80040E4E

But i am unable to find the error source in my power query model.

When i try to filter any column and select load more then i get the following erro in power query editor as well

[DataFormat.Error] We couldn't convert to Number.

Kindly advice me on this.

Thanks in advance.

Best Regards,

Shib

PaulDBrown · ‎10-02-2020

@coolshib

So it's one of your columns formatted to a number type. (Typically this is because there is a value within the column which can't be converted because it includes a non-convertible character). One way of seeing these pesky values is to change the sorting order of the rogue column (if you can identify it), and then apply whatever transformation using "Replace Values" to get rid of the unhelpful character. (Better however to do it at the source if possible)

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

View solution in original post

PaulDBrown · ‎10-02-2020

@coolshib

So it's one of your columns formatted to a number type. (Typically this is because there is a value within the column which can't be converted because it includes a non-convertible character). One way of seeing these pesky values is to change the sorting order of the rogue column (if you can identify it), and then apply whatever transformation using "Replace Values" to get rid of the unhelpful character. (Better however to do it at the source if possible)

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.