Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Reply
pabloreadi
Regular Visitor

Connector Postgre SQL DATABASE

‎06-15-2017 12:24 PM

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 , I restart computer but the same error. Help me please.

Message 1 of 26
104,735 Views
1 ACCEPTED SOLUTION
Anonymous
Not applicable
In response to pabloreadi

‎06-20-2017 01:13 AM


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



Regards,
Lydia

View solution in original post

Message 5 of 26
124,369 Views
25 REPLIES 25
pabloreadi
Regular Visitor
In response to Anonymous

‎07-06-2017 02:57 AM
Where I can download the ssl certificate for the postgresql?
Message 6 of 26
76,839 Views
0
Anonymous
Not applicable
In response to pabloreadi

‎07-07-2017 01:51 AM

@pabloreadi,


I would recommend you contact PostgreSQL support about the SSL certificate issue.

Regards,

Message 7 of 26
73,268 Views
0
pabloreadi
Regular Visitor
In response to Anonymous

‎07-31-2017 07:31 PM

I spend a lot of hours to find a simple way to copy the SSL certificate from Postgre server, but I cannot. Can you help me in this issue?

Message 8 of 26
73,018 Views
0
Chihiro
Solution Sage
Solution Sage

‎06-15-2017 12:45 PM

Try going through steps outlined in link.

http://www.odoo.yenthevg.com/connecting-powerbi-odoo/

Message 2 of 26
73,390 Views
0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.

View All