cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MarkJames Member
Member

OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005)

Hi,

 

I'm really struggling to understand the error I'm having and I really hope someone can help me.

 

In Desktop I'm using an ODBC Connection to access a number of different data sources. One of them keeps throwing up the following error:

 

01.PNG

In the ODBC connection I'm using SQL to bring back the data. I have a number of different date fields in this query.  When I have the main date at, for example '2019-02-04' the report works fine. But when I push this back to the start of 2019 it throws up this error. I'm not making any changes to the format of any data fields after it comes in to Desktop:

 

02.PNG

 

The only think I'm doing it adding a couple of custom columns and doing a bit of a clean up.

 

I've read other posts about this but none of them make sense to me. Can anyone help?

 

Thanks,

MarkJames

1 ACCEPTED SOLUTION

Accepted Solutions
MarkJames Member
Member

Re: OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005)

Hi @rocky09 ,

 

I had a similar report set up on the Power BI Service that failed to refresh but provided me with a more detailed error. It turns out one of the fields contains string values when the ODBC connection was expecting date. When I checked the set up for the original data source the field in question was shown as a string so I'm not sure where the change occured.

 

Luckily, in this instance, I think I'll be able to omit the field from the report as I don't think it's entirely necessary. Hopefully that will negate the issue.


Thanks,

MarkJames

View solution in original post

3 REPLIES 3
rocky09 Senior Member
Senior Member

Re: OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005)

check the formats of the Column.  First remove every step except source and try one by one. You will find which step is throwing the error.

 

MarkJames Member
Member

Re: OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005)

Hi @rocky09 ,

 

I had a similar report set up on the Power BI Service that failed to refresh but provided me with a more detailed error. It turns out one of the fields contains string values when the ODBC connection was expecting date. When I checked the set up for the original data source the field in question was shown as a string so I'm not sure where the change occured.

 

Luckily, in this instance, I think I'll be able to omit the field from the report as I don't think it's entirely necessary. Hopefully that will negate the issue.


Thanks,

MarkJames

View solution in original post

jjarkowsky New Member
New Member

Re: OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005)

Hi, 

 

I am receiving the same error with my data and cannot figure out how to fix it. 

Would it be possible to send me file to someone who can assist? I have been trying for hours. 

 

Thank you!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)