Forum Discussion
Directquery mode with simba obdc ( amazon athena)
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
2 Replies
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.
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
