Forum Discussion

jamespatterson's avatar
jamespatterson
Frequent Visitor
3 years ago
Solved

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