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.
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.