Forum Discussion
We couldn't authenticate with the credentials provided. Please try again - Using right credential
Hi vaishnavi_9079,
Based on your replies so far, it looks like Power BI is unable to establish a connection to the PostgreSQL server, even though your credentials are correct. The error message which you are getting "No connection could be made because the target machine actively refused it" suggests that PostgreSQL is rejecting or blocking the connection.
For now can you please check if PostgreSQL is Listening for External Connections. First open the configuration file named "postgresql.conf" which is usually found in PostgreSQL file in C drive. Use this file address : C:\Program Files\PostgreSQL\[Version]\data\. There look for the line listen_addresses='localhost' and if it’s set to 'localhost', change it to listen_addresses='*'. Now save the file and restart the PostgreSQL service.
And in the same file location as "postgresql.conf" find another file "pg_hba.conf" and make sure there is a rule that allows remote access. Like : host all all 0.0.0.0/0 md5.
If you still encounter the error, please provide ascreenshot of the full error message in Power BI.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support Team
If this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
Hi vaishnavi_9079,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
No sir still i am not able to resolve my issue. I am not understanding what's that one thing that i am doing incorrectly
Hi vaishnavi_9079,
Can you please confirm if you are looking for a solution for the original question or were you able to move forward with the suggestions and responses provided till now and got struck somewhere in between.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamHi vaishnavi_9079,
I wanted to check if you had the opportunity to go through the question and see where exactly you are struck. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.
