CQD Data Connector Type Mismatch Errors

[rafal_walisko]

Hello I'm trying to create a measure from CQD Connector data that will count all conference ID.

Measure = calculate(count(CQD[Conference Id]))

I'm getting the error of DISP_E_TYPEMISMATCH.

Is there any way to get this measure working somehow?

[v-shex-msft]

Hi @rafal_walisko,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@rafal_walisko , This is not so common, refer old issues can help

https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-DISP-E-TYPEMISMATCH/m-p/33267

https://powerusers.microsoft.com/t5/Power-Query/OLE-DB-or-ODBC-error-type-mismatch-exception-from-HR...