Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |