AWS Aurora PostgreSQL Connect Error (DMTS_PublishDatasourceToClusterErrorCode)

[ezh0ng]

Hi,

I'm trying establish Power BI Gateway to connect to AWS Aurora PostgreSQL.

But, I facing error like below.

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.

Activity ID:	2b68458b-f58a-436e-9aec-d0ea072a9147
Request ID:	28df429d-383a-adf9-4d35-7762c97353e0
Cluster URI:	https://wabi-east-asia-a-primary-redirect.analysis.windows.net/
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Fri Mar 06 2020 11:13:42 GMT+0900
Service version:	13.0.12522.196
Client version:	2002.4.021

AWS-Gateway:	Unable to connect to the data source undefined.
Underlying error code:	-2147467259
Underlying error message:	Please install Npgsql version 4.0.10.0 or earlier.
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:	PostgreSQL
Microsoft.Data.Mashup.ValueError.DataSourcePath:	~~~.ap-northeast-2.rds.amazonaws.com;postgres
Microsoft.Data.Mashup.ValueError.Reason:	DataSource.MissingClientLibrary

I already downgrading Npgsql to 4.0.10.0, but, error dosen't solved. even applied 4.7.0, encount same massages.

When I test odbc connect test on gateway environment, I got 'connection sucess' message.

Is there something I miss?

Target Server : AWS Aurora PostgreSQL

Gateway Device : Windows Server 2019 Datacenter on AWS EC2

- Npgsql 4.7.0 (~/Users/.nuget/packages/)

[v-qiuyu-msft]

Hi @ezh0ng, 

Please create a support ticket to get help. 

Best Regards,
Qiuyun Yu