Forum Discussion
Unable to connect Postgres in GCP
Team, when i am trying to connect Postgres SQL(Cloud SQL - GCP) through powerbi gateway i am getting below error message.
PowerBI Service >> PowerBI Gateway (VM in GCP) >> Postgres SQL (Cloud SQL in GCP)
On PowerBI side when when try to add datasource in manage gateway we are getting the below error
Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
Activity ID: | b1106c72-28a9-4a0e-b1a8-71fbd90aaa4a |
Request ID: | fe336d0a-10a8-d3da-5f55-aabfb21f28ed |
Cluster URI: | https://wabi-us-north-central-redirect.analysis.windows.net/ |
Status code: | 400 |
Error Code: | DMTS_PublishDatasourceToClusterErrorCode |
Time: | Tue Oct 12 2021 15:30:51 GMT+0530 (India Standard Time) |
Service version: | 13.0.16934.66 |
Client version: | 2110.1.08076-train |
dgp-dev-powerbi-gateway: | Unable to connect to the data source undefined. |
Underlying error code: | -2147467259 |
Underlying error message: | An error happened while reading data from the provider: 'No such host is known' |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.ValueError.DataSourceKind: | PostgreSQL |
Microsoft.Data.Mashup.ValueError.DataSourcePath: | abc-us-dev-dgp:us-central1:aaa-postgresql13;dev_db |
Microsoft.Data.Mashup.ValueError.Reason: | DataSource.Error |
1 Reply
- v-angzheng-msft
Community Support
Hi, arunlala
This may not be a power bi or credential issue. Please check if there is a firewall blocker.
refer:
Error Code: DMTS_PublishDatasourceToClusterErrorCode
If that will not cover your case I would recommend to open a support ticket. In my experience they are pretty good at getting back to you in a timly manner. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
