Trouble Connecting Power BI to PostgreSQL Database

[Vtnnn0102]

Hello everyone,

I’m having trouble connecting Power BI to my company’s PostgreSQL database.

Here are the details:

Connection string:
jdbc:postgresql://dev-postgre05:54356/pbi

What I tried in Power BI:

Server: dev-postgre05

Server: dev-postgre05:54356

Server: dev-postgre05:54356/pbi

Database: pbi

But I always get the following error:

> “An error happened while reading data from provider. No connection could be made because the target machine actively refused it.”

Did I enter the server and database details incorrectly, or could something else be causing this issue?

Thanks in advance for your help!

[v-lgarikapat]

Hi @Vtnnn0102 ,

Thanks for reaching out to the Microsoft fabric community forum.

@GeraldGEmerick  Thanks for your prompt response.

@Vtnnn0102 

I wanted to follow up and confirm whether you’ve had the opportunity to review the information  provided by  @GeraldGEmerick  . If you have any questions or need further clarification, please don’t hesitate to reach out.

We appreciate your collaboration and support!

Best regards,
Lakshmi.

[v-lgarikapat]

Hi @Vtnnn0102 ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,
Lakshmi.

[v-lgarikapat]

Hi @Vtnnn0102 ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,
Lakshmi.

[GeraldGEmerick · Accepted solution]

@Vtnnn0102 Make sure that you are following the guidance here: Power Query PostgreSQL connector - Power Query | Microsoft Learn

If you aren't connecting locally, ensure that there is not a firewall causing trouble.