ODBC Connection to DB2 (Direct Query/Import)

[alongi]

Hi, i am connected via the ODBC connection to a DB2 database on an AS400. We are using a System DSN, the connection works fine. Does this automatically default to Direct Query? I dont see any options for Direct Query or Import when using the ODBC connector and the DSN.

Thank You

[amitchandak]

@alongi , By default it should use import. It will only show direct query, when it is supported ?

[alongi]

Now that i see the data and the ability to transform it looks like you are correct as far as it defaulting to import. How would i be able to determine if direct query is an option though. there were any options to begin with, thanks

[v-easonf-msft · Accepted solution]

Hi， @alongi 

Yes, this automatically defaults to import. You would have to load the data before you can start visualizing the data.

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

For more details, please refer to this official document.

 Enabling Direct Query for an ODBC based connector.

 SqlODBC sample 

Best Regards,
Community Support Team _ Eason