Cloud hosted Powerbi IPs

Hi Akashdaniel , Thank you for reaching out to the Microsoft Community Forum.

 

To resolve the connection issue between Power BI and your PostgreSQL RDS instance, start by verifying that the RDS instance is publicly accessible and that your security group rules allow inbound traffic on port 5432 from Power BI’s public IPs or your machine’s IP. Use an external SQL client like pgAdmin or DBeaver from the same machine as Power BI to confirm whether the issue lies with AWS or Power BI. In Power BI, ensure you’re using the correct RDS endpoint, port, and credentials. If SSL encryption is required, download the AWS RDS SSL certificate and apply it in Power BI’s Data Source Settings.

 

Additionally, verify that PostgreSQL itself is configured to accept external connections by checking the listen_addresses setting, it should allow connections from all IPs. If you’re using a Power BI Gateway, confirm that it is properly configured, running, and using the same connection details as Power BI. If the issue persists, review the RDS logs for connection errors and check your NAT Gateway and VPC settings for potential network misconfigurations. Finally, testing the connection with an external SQL client will help you determine whether the problem is AWS-related or Power BI-specific.

 

If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.