Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Enabling direct query for a data source via an odbc driver

I'd like to create a custom data connection to access a Progress database. This would allow me to DirectQuery our student information system (Skyward). I've been importing data using an ODBC but woul...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Anonymous,

    By using the custom data connector preview feature, you would need to create a date connector project in Visual Studio to define your own connector logic.

    Based on this article, the sample that define logic that enable Direct Query for an ODBC based connector will come soon. Please keep an eye on the updates in this article, and your patience is appreciated.


    Regards,

ZappySys's avatar
ZappySys
Helper I
4 months ago

As other users mentioned, there is currently no native support for DirectQuery in the standard ODBC connector.


If you are looking for a simple solution without having to build and maintain your own custom connector from scratch, there is a pre-built option available.

ZappySys provides a free DirectQuery ODBC Connector for Power BI. This allows you to select the DirectQuery mode during the "Get Data" process, enabling real-time/live data access for ODBC sources.

You can find the full setup guide and download here: Enable Power BI DirectQuery for ODBC - Setup Guide


Note: While DirectQuery allows for instant updates, keep in mind that it has certain limitations regarding DAX functions and visual complexity compared to Import mode. However, for real-time dashboard requirements, it is a very effective workaround.