Unable to connect PostgreSQL data mart to PowerBI

[WestAlmighty]

Hello guys !

Unfortunately, I am not an expert in databases, but I have been assigned the task of connecting a data mart that needs to be used with Power BI Desktop. I've tried everything, but I can't seem to make it work.

When I test the connection using ODBC with the PostgreSQL driver, I get the message "Connection Successful." However, when I try to connect it with Power BI, I receive the following error message:

I can't connect directly because I don't know the server name. The only information I was given includes: hostname, user, password, database name, port, and the three mandatory self-signed certificates required for the connection.

I'm really out of ideas if anyone could suggest a solution, it would help me a lot.

Thank you!

[v-xiaoyan-msft]

Hi  @WestAlmighty ,

Ensure that the necessary root CA certificates are installed in the client's trusted certificate store.
You may try restart the gateway and checking the PostgreSQL database ,Disabling encryption settings has been a workaround for some users.

if it doesn't help.

I would suggest opening a Support Ticket.

If you are a Power BI Pro or Fabric licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you. 
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

Best Regards,
Community Support Team _ Caitlyn

[WestAlmighty]

Hello @v-xiaoyan-msft Thank you for your super-fast response. I have successfully converted and installed the keys in the certificate store. I have not installed a gateway, as I do not have access to the server. I can't remove encryption because it's mandatory to connect to the base. The information is stored on the servers of a service provider company, which has only provided us with connection parameters (hostname, port, database) and credentials. I can connect to the base with the psql command. When trying to connect directly through the PostgreSQL connector in Power BI, I get a different error message: "An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.' Unfortunately, my company has not planned to pay for a Power BI license, so I don't think I will be able to create a support ticket for free.