Forum Discussion
Trouble Connecting Power BI to PostgreSQL Database
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!
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.
4 Replies
Hi Vtnnn0102 ,
Thanks for reaching out to the Microsoft fabric community forum.
GeraldGEmerick Thanks for your prompt response.
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.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.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.
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.
