Skip to main content

    Power BI

    Needs Votes

    When switching from DirectQuery to Import, I want to switch without user editing.

    Vote (2) Share
    shink's profile image

    shink on 02 Sep 2019 16:33:01

    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 (DISP_E_TYPEMISMATCH))"
    ----

    It was avoided by changing the mismatched data type, but I want the data to be able to be retrieved without user changes.