Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Type mismatch error when appending tables, works with integers, but not with strings

Hello,

This is my first post, so I apologize in advance if I made any mistakes.


I have two tables that have identical columns with matching data types. However, when I try to append them together in Power Query, I encounter the following error: 'OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))'. Interestingly, when I work within the Power Query Editor, none of the columns show errors, and the tables appear to append correctly. The error only occurs during the 'close and load' process.

Furthermore, if I convert a column to a whole number, then remove errors, and then convert it back to text (essentially deleting records with text values), everything works fine. I don't understand why it won't append text columns unless the text column in the second table contains only integers.

Does this behavior ring a bell with anyone?  I really appreciate your attention.

Thanks,
Kurt

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous 

Can you provide some sample picture after appending the tables?

 

Best Regards!

Yolo Zhu

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

The problem turned out not to be part of the append process, as I initially thought. Upon trying to recreate the issue, I discovered that the error was generated downstream of the append. Ultimately, I started over from scratch and resolved the issue. I appreciate everyone's attention.

 

Thanks,
Kurt

 

Anonymous
Not applicable

Hi @Anonymous 

Based on your description, your column has string and whole number, did it like the following picture?

vxinruzhumsft_0-1721784901414.png

If it like this, you can keeo the original column, then put the number to a new column, then use the new column to append. you can refer to the following code.

try Number.FromText([Column1]) otherwise null

And you can refer to the following similar thread.

Solved: OLE DB or ODBC error: Type mismatch. (Exception fr... - Microsoft Fabric Community

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous
Not applicable

Thanks for your reply. It seems to suggest creating a new column that ignores the text rows by nulling out non-numeric values. However, I need to retain the text values during the append process. Hopefully, the following will help clarify the problem:

 

Table A
Screenshot 2024-07-24 082822.png

 

Table B

Screenshot 2024-07-24 083003.png

Append result

Screenshot 2024-07-24 082500.png

 

 

Anonymous
Not applicable

The problematic column is "VEHICLE." If I eliminate all rows with text in that column, the append operation works as expected. However, we cannot ignore vehicles with text in their identifiers.

Anonymous
Not applicable

Hi @Anonymous 

Can you provide some sample picture after appending the tables?

 

Best Regards!

Yolo Zhu

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.