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