Forum Discussion
Dataflow Connect to AWS Postgresql
Hi v-karpurapud ,
Thank you for following up on this.
As we cannot find a way to resolve it, we chose the option to use the gateway for now.
Thank you.
Hi yanain9
- Trusted Certificate: Use a trusted SSL certificate on AWS PostgreSQL. Power BI Service will accept it without additional setup.
- sslmode=require: Update your connection string to include sslmode=require to bypass certificate validation while still encrypting the connection:
Host=mydb.host.amazonaws.com;Database=mydb;Username=myuser;Password=mypassword;sslmode=require
Non-SSL Option (Not Recommended): Configure PostgreSQL to allow non-SSL connections by modifying pg_hba.conf, but this is insecure and not suitable for production.
No Certificate Upload in Power BI Service: Power BI Service doesn’t support custom certificates; rely on a trusted certificate or the sslmode=require option.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
Thank you for the answer. Poojara_D12 .
I am connecting to AWS Postgresql using Native Query as below.
Value.NativeQuery(PostgreSQL.Database("host", "db_name"), "select * from table", null, [EnableFolding=true])In that case, how can I update my connection string?
Also, when I get data from Postgresql, there is no box to put connection string.
Could you please provide how to update connection string using NativeQuery.
Thanks and best regards.