Forum Discussion

pabloreadi's avatar
pabloreadi
Regular Visitor
9 years ago
Solved

Connector Postgre SQL DATABASE

Hi, I want to get data from a PostgreSQL database but the error appear "This connector requires one or more additional components to be installed before it can be used". I installed Npgsql-3.2.4.msi...
  • Anonymous's avatar
    Anonymous
    9 years ago


    pabloreadi,

    It seems that your PostgreSQL is secured with SSL. To make Power BI Desktop work with secured PostgreSQL, you would need to copy SSL certificate for the PostgreSQL server to the machine running Power BI Desktop and import it to Windows certificate store. Because Power BI Desktop uses the windows certificate store to decide what to trust, once you tell the Windows that is running Power BI Desktop to trust the SSL certificate for the PostgreSQL server, Power BI Desktop will trust it too.

    In addition, in the configuration folder for the PostgreSQL server there is a postgresql.conf file, search it for SSL settings, there is one with the location of the SSL certificate. Take a look at the server name when you import the SSL certificate and connect from Power BI Desktop using the same server name. Then check if the above error goes away.

    There is a similar thread for your reference.
    http://community.powerbi.com/t5/Integrations-with-Files-and/Postgres-error-with-Power-BI-Desktop/td-p/8799



    Regards,
    Lydia

nmsivasankar's avatar
nmsivasankar
Icon for Advocate II rankAdvocate II
8 years ago

I am experiencing a similar problem with connecting to Postgres, Error "This connector requires one or more additional components to be installed before it can be used" appears while trying to setup a connection to Postgres. Error continues even after installing the Npgsql-4.0.3.. I am still able to connect using ODBC but i do not prefer to use the ODBC.

 

Any one managed to make this working ? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi, am still using the odbc conectar, i was talking with PowerBi support but they cant gave me any solution. Is not the best with odbc  but for now i think is the one.

    • nmsivasankar's avatar
      nmsivasankar
      Icon for Advocate II rankAdvocate II
      8 years ago

      Thanks for your response, Sad to know that MS was not able to offer you the solution.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Same issue.  New to this product and this is very disappointing.

    • rylach's avatar
      rylach
      Icon for Helper II rankHelper II
      7 years ago

      Same issue.

       

      I installed Npgsql via

       

       

      Register-PackageSource -Name nuget.org -Location https://www.nuget.org/api/v2 -ProviderName NuGet
Install-Package Npgsql -Verbose

      Restarted system, without effects. I still get the error "this connector requires one or more additional components to be installed before it can be used", just after choosing PostgreSQL data type.

       

      With odbc works without problems but can I update PowerBI Service via Power BI Gateway using ODBC?

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      How about fixing this?   How about supporting things beyond Microsoft?

       

      Very disappointing that an enterprise still can't use PowerBI effectively because of problem with PowerBI data connectors (or lack there of, or lack there of native support...)   Very dissappointing. 

       

      Apparently Google's Looker product is the way to go with this non-sense, no-reponse from MS.  They provide more native support for various database and is response to customer needs.  Unfornuately, MS is up to it's NIH (Not Invented Here) attitude.  Again very disappointing.