https://github.com/npgsql/Npgsql/releases
Following are the steps required to connect Power BI Desktop Tool to PostgreSQL Database:
- Setup PostgreSQL Client
- Connect Power BI Desktop Tool to PostgreSQL
Below are the steps that will walk you through setting up PostgreSQL Client:
Step 1: Download the latest MSI from this page and install it in your machine.
Step 2: Once this is done, you can now try connecting Power BI to PostgreSQL. However you will notice below error
Once you restart your machine, you can now connect to PostgreSQL and start playing with your data. Below are the steps for connecting Power BI Desktop Tool to PostgreSQL:
Step 1: Open pgAdmin III interface to create database, table and few records to display in your report as shown in screen capture below
Step 2: Open Power BI Desktop Tool and click ‘Get Data’ and select PostgreSQL Database as shown below
Step 3: Enter server name (in our case it is localhost), database name, username and password as shown in below screen capture
Step 4: Select required table from database and click load as shown in screen capture below
Step 5: Once data is loaded in model, you can start playing around with the data and create beautiful visualizations/reports as shown in image below and later publish it to Power BI Online Service