I am trying to connect to PostgreSQL data hosted in Amazon AWS. I am testing both direct query and import connectivity mode. While data refresh I am getting below error -
'The remote certificate is invalid according to the validation procedure.'
I was getting same error while refreshing data in Power BI desktop. I went through data source settings, unchecked encrypted connection and that fixed the issue.
I did the same process in Power BI service but still getting same error.
Note: I want to achieve this without using gateway. Any help will be appreciated.
Anonymous
6 Comments
Hi dkfd ,
So is the data source you want to connect to located on a remote machine?
Best regards,
Community Support Team Selina zhu
Anonymous - It is located on AWS. I was able to connect to it using ODBC for PostgreSQL and then installing gatweay and scheduling refresh.... But, since my data resides in AWS, I would like to achieve it using PostgreSQL connector and without gateway
Hi dkfd ,
So, if you configure the gateway, the whole refresh process is normal and successful. When you don't use the gateway, the error "remote certificate is invalid according to the validation procedure" will appear?
Best regards,
Community Support Team Selina zhu
yaronkleinHelper II
Hi dkfd ,
I have the same exact problem.
Were you able to find a solution?
I would appriricate it a lot if you will let me know.
Thanks,
YaronHi yaronklein
I did not find any other solution than to use gateway. so if we go with azure sql all is good but if you use any other db service u might have to create a gateway.
- yaronklein
Thank you dkfd !
This is what I will do.
Take care.
