Unanswered

Azure PostgreSQL connection with PowerApps

Like (0) Share

Report

Posted on 5 May 2020 23:36:12 by pavithrakc

Hello Team,

I have an Azure PostgreSQL database which I wanted to connect with PowerApps. I tried some solutions by looking at the forum threads.

I installed the following

1) On-premises data gateway

2) Added ODBC connection using the Driver called "PostgreSQL Unicode(x64)" with my Azure PostgreSQL database connection details.
Output: "Test connection is successful".
3) I also installed Npgsql version 4.0.9 according to the error message I have seen.
Output Error: "Please install Npgsql version 4.0.10.0 or earlier"

After installing Npgsql (4.0.9) and .Net Framework 4.7 version, I started seeing the following new error now:

"Credentials are missing or not valid. inner exception: The credentials provided for the PostgreSQL source are invalid. (Source at <azure_postgres_server>;<db_name>.) clientRequestId: 30b586b0-6ed8-4837-b56e-99fccc81c72d"

Find the attached screenshot for the same.

My credentials are right. Still not able to understand this failure. Looking for some suggestions around this issue.

Thanks!!

Categories:

Connectors

postgres-credenta...

All responses (2)

Answers (0)

k1rac 2 on 25 Mar 2021 at 16:03:26

Like (0)

Report

Re: Azure PostgreSQL connection with PowerApps

How did you install npgsql and where? Is it something to be installed on your local PC or in azure database? I am stuck on this part. Tried to install on my PC but somehow I do not get rid of the error "Please install Npgsql version 4.0.10.0 or earlier.
inner exception: Please install Npgsql version 4.0.10.0 or earlier."
alrezac on 07 May 2020 at 15:43:35

Like (0)

Report

Re: Azure PostgreSQL connection with PowerApps

Hi,

For some reason your connector is having issues making the connector over the API call. So because of this it is throwing an error. This will require some in depth troubleshooting so I would recommend opening a ticket with Microsoft Support. I'll include a link on how to do so below; Otherwise if any other communities members might know feel free to chime in.

If you would like to create a ticket with Microsoft Customer Support here is a link on how to do so: https://docs.microsoft.com/en-us/power-platform/admin/get-help-support

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.