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

copytac's avatar
copytac
Frequent Visitor
8 years ago

All,

 

This seems like a poor solution in my opinion. I can connect via odbc directly to the data source, with PostgreSQL driver installed, without the need for this certificate issue.

 

Simply create a system DSN in your 64 ODBC driver with the proper connection information. Once your system DSN is setup correctly, you can use the ODBC connector in power bi to connect to the data source using the system DSN.

 

Much more straightforward.

 

It doesnt make sense that my access application can access my PostgreSQL server, but PowerBI cant? Seems like a cop out to me,

Powaup's avatar
Powaup
New Member
8 years ago

I am having a hard time creating a New Data Source to SQL Server? any tips there?

 

Whether I try connecting with Windows NT or with SQL server authentication I get the following error message:

 

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

---------------------------
OK
---------------------------

 

 

Thanks

  • Chihiro's avatar
    Chihiro
    Solution Sage
    8 years ago

    I'd recommend starting new thread. Rather than tacking onto someone else's question, which isn't direcly related to your issue.

     

    At any rate, you should give more info.

    Specify what SQL Server (MS SQL version, is it Express?) you are trying to connect to.

    If you are using alias for the connection? Try using IP address suffixed by port# to test.

    Are you able to connect to it using SQL Management Studio remotely? etc etc.