Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I try to connect to Informix 11 db using 64bit ODBC driver v 4.50.00.18020. I get data correctly but query folding does not work after any filter applied. If I run diagnostics on the step with simple equal filter like
= Table.SelectRows(my_Table, each ([field1] = "01"))
I can find "OdbcQuery: FoldingWarning" that says "This ODBC driver doesn't support SQL_SP_COMPARISON. You can override this by using SqlGetInfo for SQL_SQL92_PREDICATES."
If I use BeginsWith filter like
= Table.SelectRows(my_Table, each Text.StartsWith([field2], "M"))
the warnings are following:
This ODBC driver doesn't support SQL_FN_STR_LOCATE_2. You can override this by using SqlGetInfo for SQL_STRING_FUNCTIONS.
This ODBC driver doesn't support SQL_FN_STR_LOCATE. You can override this by using SqlGetInfo for SQL_STRING_FUNCTIONS.
This ODBC driver doesn't support SQL_SP_LIKE. You can override this by using SqlGetInfo for SQL_SQL92_PREDICATES.
Is there any way how to fix it?
Hi @jirim ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
Hi @jirim ,
This seems strange - it might be worth seeing whether query folding is taking place, and what your OData source actually returns, by using this technique: https://blog.crossjoin.co.uk/2018/05/03/troubleshooting-data-refresh-performance-issues-with-odata-d...
Best Regards
Lucien
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |