ODBC ERROR

[ozgurozturk98]

Hi all,

Currently I have two ODBC connections to a source system, namely ODBC A and ODBC B. I would like to append two tables. This aggregration must be a combination of ODBC A and ODBC B.

What I have done now is that I have retrieved the two necessary tables from ODBC A and ODBC B. If I want to append these two tables with each other, I get the following error message.

(In addition, the append does work in ''Edit Queries''. But it doesn't work when i press on ''Close & Apply'').

Can you guys help me further?

Best Regards,

Özgür

[v-chuncz-msft · Accepted solution]

@ozgurozturk98,

Instead, you may use UNION Function in DAX.