Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
peter-townsend
Regular Visitor

PostgreSQL data source - connector is not configured correctly.

I am currently running the latest version of the Power BI Desktop [2.39.4526.362 64-bit (September, 2016)] on Windows 8.1.  I would like to connect to a PostgreSQL database (in this case Amazon RDS) but I am running into a seemingly intractable problem.  When I click on "Get Data...More...PostgreSQL Database" from the ribbon I immediately get the following error:

 

powerbi-postgres-error.png

 

Originally I did not have the npgsql .NET data provider installed.  So I dutifully downloaded and installed the latest version of npgsql data provider (https://github.com/npgsql/npgsql/releases/download/v3.1.8/Npgsql-3.1.8.msi).  I then rebooted my PC and tried again to configure a PostgreSQL data source.  Same error dialog appears.  I have subsequently tried installing several older versions of npgsql in place of 3.1.8, notably 3.1.7 and 2.2.3.  In all cases I have run the installer to push the npgsql.dll and mono.security.dll files into the Global Assembly Cache using the Visual Studio 2015 Tools Command Prompt:

 

gacutil.exe -i Npgsql.dll

gacutil.exe-i Mono.Security.dll

 I still get the same error.

 

Anyone having similar issues?

5 REPLIES 5
v-qiuyu-msft
Community Support
Community Support

Hi @peter-townsend,

 

Based on my test for Power BI Desktop version 2.39.4526.362 64-bit, once I run Npgsql-3.1.8.msi to install the provider and restart the computer, we are able to open the PostgreSQL Database navigator.

 

q1.PNG

 

In your scenario, please check if you have installed .NET 4.5 or higher version in the computer. Also please check if you can find any useful information in desktop trace log.

 

q2.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Did you solve this @peter-townsend?

 

I followed the exact same steps as @peter-townsend.  It still did not work.  I followed the steps from @ankitpatira to troubleshoot, still did not work.

 

  1. I have installed Microsoft Power Bi version: 2.47.4766.801 64-bit (June 2017), is that an issue @v-qiuyu-msft?
  2. I have installed Npgsql 3.2.3.
  3. I have installed VS Studio 2017 Community and added the dll files to the assembly using the command prompt.
  4. I have edited my machine.config file so it looks like this:

<system.data>
    <DbProviderFactories>
      <add name="Npgsql Data Provider" invariant="Npgsql" description=".Net Framework Data Provider for PostgreSQL Server" type="Npgsql.NpgsqlFactory, Npgsql, Version=3.2.3.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7"/>
     </DbProviderFactories>
      </system.data>

    5. I am running Windows 10 so I already have .NET framework 4.5 installed.

  6. I restart my PC, open up Power Bi and try to connect to Postgre again and I get the same message that the connector requires one or more additional components to be installed before it can be used.

 

The tracer log from my Power Bi can be found here:

https://www.sendspace.com/file/vleze0

 

How can I get this thing to work?  It's driving me crazy!

 

Thanks.

Ian

 

This is insane Microsoft. Pay the man to make an install that connects his software to Power BI handling ALL problems. PostgreSQL is the 4th most widely used database. You need to make this seemless Microsoft. Someone already went to the trouble of doing most of the hard connectivity work for free. You need to fund him to deal with the PITA nonsense part that is the difference between Power BI being The GoTo BI product for PostgreSQL, and what it currently is (only used by gluttons for punishment or the lucky who happened to have all the right combination of software versions that make it magically work).

ankitpatira
Community Champion
Community Champion

@peter-townsend Go through this article to troubleshoot and connect.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.