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/)

[ezh0ng · Accepted solution]

I solved this problem with installing msi package below.

https://github.com/npgsql/npgsql/releases/tag/v4.0.10

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[ezh0ng]

There are no issue posts about error like mine, so I post it.

- https://community.powerbi.com/t5/Issues/AWS-Aurora-PostgreSQL-Connect-Error-DMTS/idi-p/961416#M54488

Unfortunately, I'm not Pro license user yet.

Should I delete or close this one?