Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Unable to connect to aws rds-postgresql

Hi Team,

 

I have created a report in Power BI desktop using the data set from aws RDS-Postgresql. The refresh was working in desktop on clicking refresh data but after publishing the report to service I was unable to refresh or schedule refresh for the dataset with the same credentials

 

Getting error message like:

Failed to update data source credentials: An error happened while reading data from the provider: 'An attempt was made to access a socket in a way forbidden by its access permissions'Hide details

Activity ID:658e4e51-77e3-4099-8a5e-0df4f95553b5
Request ID:8c3a9b83-520d-926e-e83b-cf8427ef6ae5
Status code:400
Time:Thu Sep 08 2022 13:50:04 GMT+0000 (Coordinated Universal Time)
Service version:13.0.18988.47
Client version:2208.5.13156-train
Cluster URI:https://wabi-west-us-d-primary-redirect.analysis.windows.net/

 

The rds hosted in private network, i.e VPC.

 

How can I make this connection successful and schedul the refresh.

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

HI @Anonymous 

 

You will need to install Power BI Gateway on a VM inside the VPC that can connect to the RDS-Postgresql

 

And then configure the gateway to connect to the data source via the Gateway.

 

Here are more details: Power Query PostgreSQL connector - Power Query | Microsoft Docs





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

1 REPLY 1
GilbertQ
Super User
Super User

HI @Anonymous 

 

You will need to install Power BI Gateway on a VM inside the VPC that can connect to the RDS-Postgresql

 

And then configure the gateway to connect to the data source via the Gateway.

 

Here are more details: Power Query PostgreSQL connector - Power Query | Microsoft Docs





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.