Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

I am not able to connect Postgre SQL DATABASE

Hi Friends,

 

I am not able to connect post gre sql db in power BI desktop. getting the trail mail error.

 

The connector is not  configured correctly.

this connector requires one or more additional components to be  installed before  it can be used.

 

Kindly check the above error and please give me some solutions.

 

Awaiting for your help.

 

Regards,

Rajendra

 

 

Need Help

8 Replies

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

    Hi Anonymous,

     

    From the error message, the issue is caused by that the connector is not be configured properly. Please refer to this article to configure connector again: Power BI Connectivity to PostgreSQL.

     

    Best Regards,
    Qiuyun Yu

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Yu,

       

      we have raised firewall request to connect our POSTGRE SQL to access our Data available in DB.

       

      But still we are facing the below issue. 

       

      Kindly check and let us know if any changes required.

       

      • markcaple's avatar
        markcaple
        New Member
        9 years ago

        Having tried to get this going for a few hours with no success decided to change the approach and use a postgreSQL ODBC driver and it worked straight away.

         

        First get the driver from

         

        https://www.postgresql.org/ftp/odbc/versions/msi/

         

        I downloaded the psqlodbc_09_06_0100-x64.zip and ran psqlodbc_x64.msi

         

        Now click on 'Get Data' in PowerBI and select ODBC. Choose  <None> in Data source name (DSN) and click on Advanced Options and enter a connection string which you can find at

         

        https://www.connectionstrings.com/postgresql/

         

        I used something like

         

        Driver={PostgreSQL ANSI(x64)};Server=rds-postgresql-xxxx-warehouse.cftg4xxxxxt.ap-southeast-2.rds.amazonaws.com;Port=5432;Database=myDatabase;

         

        My server is an AWS server. The most important part is the driver name which you can search for in your ODBC settings and you will see a warning icon by the side of the connect string until you get this right.