Data Type with searchable property UNSEARCHABLE should be SEARCHABLE or ALL_EXCEP_LIKE

[QIAO]

I got error message like "Data Type of column courseid with searchable property UNSEARCHABLE should be SEARCHABLE or ALL_EXCEPT_LIKE. You can override the supported data types from ODBC driver using SQLGetTypeInfo." when loading data from a table through Direct Query. The problem lies the Power BI does not call SQLGetTypeInfo at all. How can I set data type to SEARCHABLE  while Power BI does not call SQLAttributes/SQLGetTypeInfo, is there any other way?

[v-qiuyu-msft]

Hi @QIAO,

Which data source did you connect to? Did the error occur when you get data in Power BI desktop? 

Best Regards,
Qiuyun Yu

[QIAO]

It happens when create a visual, and the data source is Athena which we connect through ODBC driver.

The problem lies in how to set data type to SEARCHABLE or POWER BI supports DIRECT QUERY through ODBC driver or not. One thing is sure that Power BI does not call SQLAttributes/SQLGetTypeInfo to get searchable data type as we can see in the log.

[QIAO]

Does Power BI support Direct Query with ODBC driver??? or something hardcoded??

[v-qiuyu-msft]

Hi @QIAO,

ODBC data source doesn't support DirectQuery, see: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources

Also Power BI don't have SEARCHABLE data type as well. 

Best Regards,
Qiuyun Yu