Data source setting error for schedule refresh RDS AWS Postgres

Question

Hi,&nbsp;I can connect with rds aws postgres from power bi desktop and build the report. After published on power bi service getting an error for Data source Credential setup.There are many blogs regarding the same issue. Mostly are recommending the on-premises gateway, but my database is on cloud, do I really need gateway in this case also. If yes, please provide the proper step for setup gateway for CLOUD Database.&nbsp;Would anyone suggest appropriate steps for connecting rds aws postgres database?&nbsp;&nbsp;Summary :1. Power Bi Desktop connecting with rds aws postgres db and also refresh.2. Error occuring on Power Bi service after publish3. Error in putting credentail in "Data Source Credential"&nbsp;&nbsp;Any solution response would be much appreciated.&nbsp;ThanksRam

ram_nrt · Answer

Hi&nbsp;GilbertQ&nbsp;Thank you for your attention. I am not sure about this. Would you please explain the steps to do so?&nbsp;Thank you in advance.&nbsp;

ram_nrt · Answer

Hi&nbsp;GilbertQ&nbsp;,I have already install the SSL certificate, but still the same issue. And after that only I am able to connect with power bi desktop to rds aws.But I mentioned already, the issue is at power bi service after published the desktop report.&nbsp;Any other suggestion ?&nbsp;Thank you

gilbertq · Answer

Hi&nbsp;ram_nrt&nbsp;
&nbsp;
According to the error, it has to do with an invalid SSL Certificate.
&nbsp;
I do vaguely recall where having the Gateway installed allowed the users to then also install a valid SSL Certificate in order to then connect to the RDS.

gilbertq · Answer

Hi there
&nbsp;
Here are the steps on how to get this working with the Gateway.
&nbsp;
Solved: Connecting to PostgresSQL hosted on AWS RDS? - Microsoft Power BI Community

gilbertq · Answer

Hi&nbsp;ram_nrt&nbsp;
&nbsp;
As far as I can understand you would need to connect this to your Gateway Server, where you would also install the SSL Certificate to get it working?

Forum Discussion

Data source setting error for schedule refresh RDS AWS Postgres

5 Replies

Related content

Postgre connection

Set payload for scheduled jobs

Difficulties setting up Postgres in OnPrem Data Gateway

Scheduled pipelines failing

Postgres conection