OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)).

[rusgesig]

How can I find which column is causing the exception?

[mlsx4]

Hi @rusgesig 

It is probably happening because you're doing some transformation from the original data types.. You should go into Power Query Editor, navigate through steps and remove any type change you've made. Once done, check if that works.

[rusgesig]

It does not work. The only applie step in query editor is 'Source'.

That's beside the point however, if there's an exception why can't Power BI tell me where it is?

[mlsx4]

Are you trying to append two queries?

If so, check that each column matches between both tables

[rusgesig]

Even when removing all steps from query editor except 'source' the error persists.
After deleting all relationships, limiting the dataset to one table, the error persists.