Directquery mode with simba obdc ( amazon athena)

[ludovicLaurent]

Hi

   I want using amazon athena connection not with   amazon connector ( that generate  AmazonAthena.Databases instruction in powerquery)  but odbc connector  (that generate Odbc.DataSource  instruction in powerquery) 

    But i don't if it's possible to use the odbc connector with directquery   ?

    if it's possible , how activate directquery mode  ( the option is not display in the pop up where we define the connection) 


thanks for your help

[v-stephen-msft]

Hi @ludovicLaurent ,

ODBC extensions can optionally enable DirectQuery mode, allowing Power BI to dynamically generate queries at runtime without precaching the user's data model.

I'd like to suggest you take a look at the following document to create a custom connector with 'direct query' enabled on odbc driver if helps:

Enabling DirectQuery for an ODBC-based Power Query connector - Power Query | Microsoft Learn

Best Regards,

Stephen Tao

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

[ludovicLaurent]

Hi 
if i understand well , i have to create a pq file  in the folder corresponding to personnal connection in the gateway 


I have to change the example file :  https://github.com/microsoft/DataConnectors/tree/master/samples/ODBC/SqlODBC/SqlODBC.pq  ?
 has somebody do this ?  and how i have to name the file to associate it with the powerbi connection in the powerbi service

Thanks