Forum Discussion

peter-townsend's avatar
peter-townsend
Regular Visitor
9 years ago

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:

 

 

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?

Need Help

5 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    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.

     

     

    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.

     

     

    Best Regards,
    Qiuyun Yu

    • ianwuk's avatar
      ianwuk
      Helper III
      9 years ago

      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