Custom ODBC Connector Property Unsearchable Error

[zua]

Hello, 

I have a problem with a custom ODBC connector for a SAP HANA database. 

I use native queries to access tables in the database and to fold the calculation. 

But I have a problem with columns that have datatype double in the db and numeric in Power Query.

For example I filter a corresponding column, which will result in a query that is not supported by direct query.

The diagnosis says "data type of column XY with searchable property UNSEARCHABLE should be SEARCHABLE or ALL_EXCEPT_LIKE".

All other columns (with different data types) are filterable with direct query and query folding. 

I tried to fix the searchable property of the columns, but that does not fix the problem.

Does anybody else have this problem? And does anyone have got an idea what the problem is and how to fix it?

Thank you! 

[zua]

Hello @v-xinruzhu-msft,

this connector does not work for my purpose, 

which is to offer direct query, query folding and ssl encryption. 

Do you have an idea what the error message is about?

[pj-spoelders]

Hi @zua Have you found a solution or workaround for this problem yet? We are experiencing exactly the same issue with a different custom connector we've built and are using .. - ODBC-based, - using DirectQuery connectivity mode, - using a NativeQuery and using [EnableFolding =true]. We also only have this issue with the DOUBLE PRECISION datatype. We tried similar workaround as to what you tried (Set the columns to SEARCHABLE via SQLGetTypeInfo ) to no avail.

[v-xinruzhu-msft]

Hi @zua , 

In power bi desktop, it offered the SAP HANA database connector, you can try to use the connector to connect the database.

And you can refer to the following link about the connector.

Power Query SAP HANA database connector - Power Query | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.