In Power BI, you don’t get to DirectQuery with any ODBC driver or some of the data sources like Salesforce, by default. Before you start to visualize the data, you would have to load the data. In this article, you will learn how you can use Progress DataDirect ODBC drivers to DirectQuery with Progress DataDirect PostgreSQL ODBC driver.
To enable DirectQuery, Microsoft provides a Data Connector SDK. Using that, you would have to create an extension that enables DirectQuery. But this can be tricky. If you are not sure how to do this, don’t worry, Progress DataDirect has got you covered.
In this article, you will see how you can enable DirectQuery for PostgreSQL using the Progress DataDirect PostgreSQL ODBC driver. You can use this same method for any DataDirect ODBC drivers. We will provide you with Power BI connectors that enable DirectQuery for any data source.
If your Power BI is already running, save your work and Restart Power BI for the extension to show up.
We hope this article helped you with how you can Direct Query Progress DataDirect PostgreSQL ODBC drivers. All the Progress DataDirect ODBC drivers like Salesforce, SQL Server, Oracle, IBM DB2, PostgreSQL, MySQL, etc., and the drivers you can build using OpenAccess SDK are fully compliant with ODBC standards and are internally certified to work with Power BI. Feel free to try these for your projects and if you have any questions or issues, feel free to contact us.