cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jasonkovac3 Frequent Visitor
Frequent Visitor

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

hey there, guys, someone please HELP me solve this problem im facing in Power Bi Desktop.

 

Everytime i change sources from one excel to another excel (because the datat needed to be updated, and i apply changes by clicking "CLOSE AND APPLY" from the Edit Query, i get this message EVERY SINGLE TIME:  

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

 

Its so anoying because i ve tried almost everything that ive read online, ive even noticed that my Filters dont seem be be chaging in the list of filters in "Page Level Filters" they seem to stick to the exact exact same at the previous excel document, (could that be the issue)

 

Im facing these two problems and i have a feeling that the filters showing up to be the same from my previous excel document, that it has something to do with a mismatch of not having the same text as my new colom for the filters from my new excel document.

 

For example:

 

Excel document 1 has the filter: "Text 1"

Excel document 2 has the filter: "Text 2"

I want the filter to show "Text 2"

Now ive change the soucre of excel in the EDIT QUERIES" page from Excel document 1 to Excel document 2.

When i got to apply the changes ive made in the EDIT QUERIES, the message: "OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))" comes up.

and when i go to  refresh, i cant, it gives me the same messages error.

and when i go to look at the filters in the PAGE LEVEL FILTERS, still no change and still has "Text 1" as filter and not "Text 2"

 

WHY

 

PLEASE HELP !!!

 

"I CANNOT FULLY UNDERSTAND WHAT IS THIS ERROR MESSAGE:

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

 

Thanks,

Jason Kovac

 

3 REPLIES 3
Community Support Team
Community Support Team

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

HI @jasonkovac3 ,

This issue appears when your data structure changes and data type conversion failed.(due to data type not matched)

Can you confirm these files has same data structure?(e.g. data type, field name, separator... ) 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
jasonkovac3 Frequent Visitor
Frequent Visitor

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

when you mean, "Data structure" can you give more details, im not sure i quite understand.

Community Support Team
Community Support Team

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

HI @jasonkovac3 ,

>>when you mean, "Data structure" can you give more details, im not sure i quite understand.

It means you query table structure.(fields type, name, query steps...)

BTW, you can also take a look at following link about same issue:

OLE DB or ODBC error DISP_E_TYPEMISMATCH

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |