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) ...
Need Help
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

     

      • jeffwinchell's avatar
        jeffwinchell
        Advocate I
        8 years ago

        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).