Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 37 | |
| 33 | |
| 29 | |
| 27 |
| User | Count |
|---|---|
| 133 | |
| 104 | |
| 61 | |
| 59 | |
| 55 |