When switching from DirectQuery to Import, I want to switch without user editing.
The following error occurred when switching the connection method from DirectQuery to Import for the same data source.
OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISPETYPEMISMATCH))"
It was avoided by changing the mismatched data type, but I want the data to be able to be retrieved without user changes.