Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
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 |
---|---|
9 | |
8 | |
4 | |
2 | |
2 |