Converting Direct Query mode to Import mode?

[ashmozzart]

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

[v-jiascu-msft]

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

[GilbertQ]

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]

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]

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?