Forum Discussion
Dataflow - Multiple calls to Postgres AWS db
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.
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
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- V-lianl-msftCommunity Support
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
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.