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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
OwenC
Frequent Visitor

How to Append Tables OLE DB or ODBC error

Hi, I need some help with appending 3 tables together. I am getting this OLE DB or ODBC error when I apply the query.

I have 3 tables : table1, table2, table3

Originally I appended table1 and table2 together without issue. However, once I tried to also append table3, it started getting this error. 

I have ensured all the data types are the same by going to 'transform data' and copying the 'changed type' from table1 to table3 (I did the same step when I appended table1 and table2).

What is causing the error and how do I fix it? All three tables have the same columns and in excel, the format of it all looks the same 

image (8).png

2 REPLIES 2
NaveenGandhi
Super User
Super User

Hi @OwenC 

Check if the below solution works.

https://community.fabric.microsoft.com/t5/Power-Query/OLE-DB-or-ODBC-error-type-mismatch-exception-f...

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

Hi Naveen, thanks, ill check over the data. Do you have any other suggestion?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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