Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
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.
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
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?
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
85 | |
65 | |
64 |