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 distur...
Need Help
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?