Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
217 | |
89 | |
76 | |
67 | |
60 |