Drivers for 32-Bit and 64-Bit Platforms : The PostgreSQL Wire Protocol Driver : Accessing PostgreSQL data with Power BI

Accessing PostgreSQL data with Power BI

After you have configured your data source, you can use the driver to access your PostgreSQL data with Power BI. Power BI is a business intelligence software program that allows you to easily create reports and visualized representations of your data. By using the driver with Power BI, you can improve performance when retrieving data while leveraging the driver's relational mapping tools.

To use the driver to access data with Power BI:

1. Navigate to the \tools\Power BI subdirectory of the Progress DataDirect installation directory; then, locate the Power BI connector file DataDirectPostgreSQL.pqx, and the installation batch file install.bat.

2. Run the install.bat file. The following operations are executed by running the install.batfile.

The DataDirectPostgreSQL.pqx file is copied to the following directory.

%USERPROFILE%\Documents\Power BI Desktop\Custom Connectors

The following Windows registry entry is updated.

HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Power BI Desktop\TrustedCertificateThumbprints

3. Open the Power BI desktop application.

4. From the Get Data window, navigate to Other > DataDirect PostgreSQL Connector.

5. Click Connect. Then, from the DataDirect PostgreSQL Connector pop-up, provide the following information. Then, click OK.

Data Source: Enter a name for the data source. For example, PostgreSQL ODBC DSN.

SQL Statement: If desired, provide a SQL command.

Data Connectivity mode:

Select Import to import data to Power BI.

Select DirectQuery to query live data. (For details, including limitations, refer to the Microsoft Power BI article Use DirectQuery in Power BI Desktop.)

6. Enter authentication information when prompted. Once connected, the Navigator window displays schema and table information.

7. Select and load tables. Then, prepare your Power BI dashboard as desired.

Results:

You have successfully accessed your data and are now ready to create reports with Power BI. For more information, refer to the Power BI product documentation at Power BI documentation.