web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Not able to connect P...
Power Apps
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
 
 
I have the same question (0)
  • lbendlin Profile Picture
    8,479 Super User 2025 Season 2 on at
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard