Showing results for 
Search instead for 
Did you mean: 

Configuring Power BI Connectivity to PostgreSQL Database


Power BI Desktop, PostgreSQL Database, pgAdmin III, Visual Studio 2008 or higher




Power BI supports connectivity to different databases such as SQL Server, MySQL, Oracle and many more (list of all supported databases given here ). By providing necessary details such as server name, database name, username & password, you can easily connect to database and start exploring data using different visualizations in the form of reports/dashboards.


This article will walk you through the necessary steps required to configure in your system before establishing connection of Power BI Desktop Tool to PostgreSQL Database.

After installation of PostgreSQL database in your machine, if you try connecting Power BI Desktop Tool to PostgreSQL Database, you will get following error as shown in the screenshot below:




















Following are the steps required to connect Power BI Desktop Tool to PostgreSQL Database:


  1. Setup PostgreSQL Client
  2. 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


Thank you for your post. but it doesn't helped me. Is there any other idea? Could you please provide us with the ininformation ?

Great post @ashishrj.

If using npgsql v3.x.x there no longer any need for monosecurity.dll.


Also, if you select the option to install to the GAC during install, you will not need to copy the dll into windows assembly.


This may help others as it took me a while to find the answer.



We follow all the steps suggested, but can not connect to our PostgreSQL base.
We have a hosted basis of AWS.




I second the previous message. Postgresql connection doesn't work with AWS and it is a huge limitation. I know you guys are trying to push for Azure, but AWS is currently the market leader and most startup companies use the PostgreSQL databases from AWS. When is the fix coming ?


Also, as a sidenote: I create an account for Power BI. Why do I need to create a different login password to write here ? That is pretty annoying.


Hope I your Postgresql fix is coming soon !





I have been able to import a table from a PostgreSQL database and I have a created several graphs in Power BI. 
Nevertheless, I have a new table now in the database with a different name (but the same table structure).

Can I replace the old table for the new table to load the data easily into the template? And just refresh the graphs?


Thank you in advance for your help.


Kind regards, 


Any way to do Native Query with SELECT WHERE statements?

Let's see that again but this time put PostgreSQL on a remote server running SSL encryption (using LetsEncrypt).

Hello, my conecction works at desktop level, but when I upload it to Power BI Web it does not work. I tried to configure it here:




but I can´t do it. This mesage appears:




Can you please help me?

Thank you.



I think it might be due not having a gateway installed...

I have a gateway an it works fine with my MySQL connections but it doesn't work with Postgres

What is your favorite Power BI feature released this month?