Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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