search

sgoley / DirectQuery-for-ODBC-in-PowerBI

Direct Query for PostgreSQL via ODBC with SSL
MIT License
14 stars 9 forks source link

MySQL DQ Counln't load the data for this visual #9

Open francesco-clementi opened 4 years ago

francesco-clementi commented 4 years ago

Error: OLE DB or ORDBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.

I just tried to put columns on a table visual.

Any help?

sgoley commented 4 years ago

As noted in my project for this repo DQ Project - unfortunately the MySQL branch of this is still in a "To-Do" phase: #7

sgoley commented 3 years ago

Was able to find some time to spend on the MySQL connector. This is where I documented the issues that I found with it and my first pass at a fix: https://stackoverflow.com/questions/64944320/3-issues-with-sqlgettypeinfo-for-custom-connector-powerbi

Fero58 commented 3 months ago

Hello @sgoley we are facing similar issues on a custom Connector for SAP HANA in Direct Query. Everything works fine, just the data type "DOUBLE" is not foldable. Without a custom navigation table, the double data type columns are foldable. When we add custom Navigation table due to enable SAP HANA Input Parameters with a function the double data type columns could not be recognized anymore. Tracing shows me following error for this columns "Data Type of column XY with searchable property UNSEARCHABLE should be SEARCHABLE or ALL_EXCEPT_LIKE. You can override the supported data types from ODBC driver using SQLGetTypeInfo. We cannot filter, use in report and also cannot cast in Power Query. Other Column Types are working fine.

So could you explain us, how you solve this problem. Your article at stackoverflow is not available anymore.

Greetings, Ferhat