Dataflow - Multiple calls to Postgres AWS db

[Anonymous]

Hi

We are unable to save or get through the validation for some of our dataflows.  We notice there are multiple calls to our Postgres instance. 

Does anyone know what happens during validation?  We are joining 4 tables and there is a union statement within the function. 

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Verify that you are entering correct credentials.
Check if RDS instance is up and running.
Check if Inbound and Outbound rules are modified and access is given to the IP addresses you are trying to connect from/to.
Check if the AWS public access key is the right one and its working.

You can refer to this thread:

https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666 

https://community.powerbi.com/t5/Community-Blog/Configuring-Power-BI-Connectivity-to-PostgreSQL-Database/ba-p/12567 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.