Forum Discussion
Helper IVConnecting PostgreSQL hosted in Google Cloud Platform
Hi Anonymous after discussing with my DevOps, the root cause of this problem is not with the SSL certificate. Rather, it was with the proxy connection where the request was refused. When he gave me the principal IP to connect with, all problems solved. I will close this case now. Thank you for your response.
Super UserAlex_Ooi , Power BI will only take SSL enabled connection and you have load SSL certificate to windows
Do not miss any step in this -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/
Helper IVHi amitchandak appreciate your reply. As mentioned in my post, that was the first thing I did.
Unfortunately that solution only worked when you're hosting your server on AWS. I am wondering if there is something similar for GCP that I could proceed with the other steps?
Hi Alex_Ooi,
In fact, I think power bi may only support the scenario that you mentioned. For any advanced operations or other redirections, I don't think it is impossible to achieve.
Any other data connector drivers or API interfaces to link/package your data source connections with other authorizations modes without SSL?Regards,
Xiaoxin Sheng
- Alex_Ooi
Hi Anonymous after discussing with my DevOps, the root cause of this problem is not with the SSL certificate. Rather, it was with the proxy connection where the request was refused. When he gave me the principal IP to connect with, all problems solved. I will close this case now. Thank you for your response.