The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I keep getting errors trying to connect to a postgres SQL rds.amazonaws.com.
I have looked all around the places and tested but none seem to work. The only way i can get it working is by edit permission - untick encrypt connection and reconnect it again. The only issue with this is that not all the data/tables are shown. I been spending the last week trying to connect, restart PC , and installed drivers but nothing work.
I can connect this on tableau postgres connector without any issues in less than 10 seconds - I just don't understand why it's so difficult with powerbi postgres connector. The only thing i noticed is that powerbi postgres connector doesn't require a port number so this might be the problem it causing? But i have no idea how to insert a port number if there is no box for this within powerbi progres connector.
Now through odbc driver.
I created a video to solve this problem.
Video link: https://youtu.be/a641lOBoqUw
Hi, @Anonymous
Please refer to the following link, hope it can help you.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , please refer to the steps in these solutions. do not miss any steps
https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/
https://niftit.com/connecting-power-bi-to-postgresql/
User | Count |
---|---|
78 | |
77 | |
38 | |
31 | |
28 |
User | Count |
---|---|
106 | |
98 | |
55 | |
49 | |
47 |