Forum Discussion

ashmozzart's avatar
ashmozzart
Frequent Visitor
8 years ago

Converting Direct Query mode to Import mode?

Hi,

I did reports using Azure SQL DataWareHouse as the Data source using Direct Query mode.I built all the reports.Now i want to change the Direct the Direct Query mode to Import mode without disturbing the Reports.When i tried to change the mode from DQ to import,I am getting the following error.

OLE DB or ODBC error DISP_E_TYPEMISMATCH

OLE DB or ODBC error 0x80040e4e

 

Please suggest me the solution.As the reports are already built,Without disturbing them i need to just change the mode.

 

Thanks,

Ash

Need Help

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago

    Hi ashmozzart

     

    When you click on the Data Source in the Query Editor you should get the option to change it from DirectQuery to Import Mode.

     

    • ashmozzart's avatar
      ashmozzart
      Frequent Visitor
      8 years ago

      Hi Guavaq,

      Thanks for the response.As i said, When i do that i am getting this error.

      OLE DB or ODBC error DISP_E_TYPEMISMATCH

      OLE DB or ODBC error 0x80040e4e

       

      Thanks,

      Ash

      • GilbertQ's avatar
        GilbertQ
        Super User
        8 years ago

        Hi ashmozzart

         

        That would appear to them be a potential issue with the way you are connecting to your data.


        What data source are you using?

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi ashmozzart,

     

    I can't reproduce your issue. But I think this post would help. Could you please try to delete the steps in the Query Editor? You can duplicate the file for backup first.

     

    Best Regards!

    Dale