Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Unanswered

Not able to connect Power Apps with AWS Aurora PostgreSQL via Onpremises Data Gateway

(0) ShareShare
ReportReport
Posted on by
Hi,
 
I am trying to connect AWS Aurora PostgreSQL via Onpremises Data Gateway to Power Apps, but while adding  this connection I am getting this error :
 
Please install Npgsql version 4.0.16.0 or earlier.
     inner exception: Please install Npgsql version 4.0.16.0 or earlier.
clientRequestId: 8d9e140b-1219-4939-9e5e-c9c9dd33af3e
Session ID: 3e32a59c-2d94-4154-beea-c078e1a1f309
 
I have gone through multiple posts related to this error to fix this issue but have not got any success. I have tried installing Npgsql from the github Releases · npgsql/npgsql on the EC2 instances running the Onprem Data Gateway. Have tried installing 4.0.16.0, 4.0.14.0, 4.0.13.0 and even 4.0.10.0 selecting the GAC installation and restarting gateway and even rebooting the VM, but nothing works. Also have tried using enabling the Encrypt Connection option.
 
Is there a defined solution to this process.
 
Thanks,
Anurag
 
 
  • lbendlin Profile Picture
    lbendlin 7,597 on at
    Not able to connect Power Apps with AWS Aurora PostgreSQL via Onpremises Data Gateway
    You need to install the npgsql files on all gateway cluster members.  Our preferred process is to "borrow"  these files from a Power BI Desktop install and copy them manually to the correct folder on the gateways.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard