Forum Discussion
Connection error (No such host is known) to a postgreSQL database hosted on AWS using PowerBI Dektop
Hi gougou007 ,
Before doing so, can you check if this machine can access the postgreSQL instance?
How do you connect to an AWS-hosted postgreSQL database?
Try the method provided by edwardrmiles and see if this solves the problem.
Solved: Re: Connecting to PostgresSQL hosted on AWS RDS? - Microsoft Fabric Community
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
- Your 1st question : can you check if this machine can access the postgreSQL instance?
My answer : How can I check that ? I don't understand well your question.
- Yours 2nd question : How do you connect to an AWS-hosted postgreSQL database?
My answer : I'm using powerBI desktop (below some screenshots)
1- after opening powerBI
2- information I entered
When i did it the error message appeared.
- I followed the instructions in the link but the error reappeared. I don't know if I installed NpgSQL correctly. Do you have another method to install it? (I used Visual Studio with packet managerconsole) here is a screenshot.