Power BI Report - OLE DB or ODBC error

[jamespatterson]

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

[v-luwang-msft · Accepted solution]

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