GCP BQ Big Query Table import error if table has PK constraints

Error:  Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)). '.   How data is read and h...