Forum Discussion

alongi's avatar
alongi
Frequent Visitor
4 years ago
Solved

ODBC Connection to DB2 (Direct Query/Import)

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...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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

alongi's avatar
alongi
Frequent Visitor
4 years ago

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's avatar
v-easonf-msft
Community Support
4 years ago

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