Forum Discussion
Power BI Report - OLE DB or ODBC error
Hi all,
Application: Power BI
Version: 2.110.805.0 64-bit (October 2022)
Having an issue where a Power BI report that is published to our PBI server is displaying the ODE to ODBC error. The data source is connected to a SAP gateway and using DirectQuery. DAX sits in a calculation table within the "Sales High Level View" data source. This was working until this mornings auto-refresh, before which no changes were made. If I connect to the "V2 query modes dates v2" data source from a blank workbook, it works. If I do the same for "Sales High Level View", it does not work.
This is the error screen I am getting
Solutions attempted:
-Restarting he application and machine
-Republishing the workbook
-Reconnecting the workbook
-Clearing workbook permissions and re-authenticating
Thanks for any help
Hi jamespatterson ,
Refer the below and check if it is helpful:
https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-DISP-E-TYPEMISMATCH/td-p/33267
Best Regards
Lucien
1 Reply
- v-luwang-msftCommunity Support
Hi jamespatterson ,
Refer the below and check if it is helpful:
https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-DISP-E-TYPEMISMATCH/td-p/33267
Best Regards
Lucien