MySQL DQ Counln't load the data for this visual

[francesco-clementi]

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]

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]

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]

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