Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
jamespatterson
Frequent Visitor

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.

 

pbi.PNG

 

This is the error screen I am getting

 

pbi1.PNG

Solutions attempted:
-Restarting he application and machine
-Republishing the workbook
-Reconnecting the workbook
-Clearing workbook permissions and re-authenticating

 

Thanks for any help

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

1 REPLY 1
v-luwang-msft
Community Support
Community 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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.