Forum Discussion
We couldn't authenticate with the credentials provided. Please try again - Using right credential
Hi vaishnavi_9079,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you are facing issue with authentication when trying to get data from PostgreSQL. As tharunkumarRTK already responded to your query, please go through his response and mark it as solution if it solves your issue.
I would also take a moment to thank tharunkumarRTK, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
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.
Sir you understood it right that i am getting issue with authentication to get data from postgresql.
I am really thankful to tharunkumarRTK sir for guiding me.
I have tried everything that sir has told me but it is not working.
I am not getting what's the issue which we are not able to catch.
I'll be really grateful if u can help me out on this.
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.Then save the file and restart PostgreSQL service again. And also check if PostgreSQL is running and listening on Port number 5432. To check open CMD on PostgreSQL server and run "netstat -ano | findstr 5432". If you don’t see any results, PostgreSQL is not listening on the correct port and may need to be restarted.
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 TeamIf 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