Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Schedule refresh with PostgreSQL hosted on AWS

Hi.

 

I'm able to connect to PostgreSql hosted on AWS and able to do refresh in Power BI desktop but I'm not able to do refresh in service.

I have followed all the steps mentioned in article - https://community.fabric.microsoft.com/t5/Desktop/The-remote-certificate-is-invalid-according-to-the-validation/m-p/531475

 

Error:

 

 

I had dowloaded the aws key and converted it to PKCS#7/P7B and then added in trusted certificates.

Let me know what I'm doing wrong,

Tips and Tricks

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Do i need to configure gateway on on premise machine or AWS EC2 machine

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        The gateway needs direct line of sight to the data source. So on AWS.