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.
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"
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))"
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... )
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: