Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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/)
Solved! Go to Solution.
I solved this problem with installing msi package below.
I solved this problem with installing msi package below.
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".
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?