Forum Discussion
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.
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
1 Reply
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