Power BI service - PostgreSQL hosted in Amazon aws - refresh issue

[dkfd]

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 

[Anonymous]

Hi @dkfd ,

So is the data source you want to connect to located on a remote machine?

Best regards,

Community Support Team Selina zhu

[dkfd]

@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

[Anonymous]

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

[yaronklein]

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,
Yaron

[dkfd]

Hi @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.