PostgreSQL can't be connected by Power Apps

Question

PostgreSQL can't be connected by Power Apps

Irvanda 116

I am trying to setup a connection on Power Apps to PostgreSQL flexible servers on Azure.

The network uses public access and allows all IPs on the PostgreSQL firewall.

I get an error related to credentials when setting up a PostgreSQL connection on Power Apps. I have also tried resetting the password but the error still appears. User's image

Please advice, thank you.

Mallaiah Sangi 95 Reputation points Microsoft External Staff

2025-03-13T04:20:09.8233333+00:00
Hi @Irvanda

Thanks for the Question and using Microsoft Q&A platform

As per my understanding, your facing connection issue for PostgreSQL flexible servers Via Power Apps.

If you're having trouble connecting PostgreSQL to Power Apps, here are a few steps you can try to troubleshoot the issue:

Ensure the Correct Connector: Power Apps doesn't have a native PostgreSQL connector. You need to use a third-party connector or a custom connector to connect to PostgreSQL. Check if you're using a reliable connector, such as the "PostgreSQL".

Check Connection Credentials: Double-check the credentials (username, password, host, port) you are using to connect. Make sure they are accurate and correspond to the PostgreSQL database instance you're trying to connect to.

Database Access: Ensure that your PostgreSQL server allows remote connections, if applicable. The server’s pg_hba.conf file should allow connections from your Power Apps IP address or domain. I hope, this response will address your query and helped you to overcome on your challenges. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Irvanda 116 Reputation points

2025-03-13T05:29:25.3833333+00:00

Hi @Mallaiah Sangi

Thanks for the answer.

In the "Ensure the Correct Connector" section, what do you mean by "third-party connector or a custom connector to connect to PostgreSQL."?

For "Check Connection Credentials", I made sure it was correct.

Then for "Database Access", PostgreSQL on Azure can actually be accessed from a local device. However, when accessed with Power Apps on a web browser, the error occurred.

I tried to simulate creating PostgreSQL on Google Cloud Platform and tried to set up a connection on Power Apps. The result was that it could connect without any problems.

Why does the problem only occur if Power Apps creates a connection to PostgreSQL on Azure? Is there anything else that needs to be ensured on PostgreSQL in Azure so that Power Apps can connect?
Mallaiah Sangi 95 Reputation points Microsoft External Staff

2025-03-13T07:12:17.0666667+00:00
Hi Irvanda

Thanks for your response.

Please find the documentation link. you will get more details connect to the PostgreSQL server via the following alternative tools:

psql – a terminal-based utility to connect to the PostgreSQL server.

pgAdmin – a web-based tool to connect to the PostgreSQL server. https://neon.tech/postgresql/postgresql-getting-started/connect-to-postgresql-database I hope, this response will address your query and helped you to overcome on your challenges.
ShaktiSingh-MSFT 16,251 Reputation points

2025-03-13T08:53:58.08+00:00
Hi Irvanda •

Welcome to Microsoft Q&A forum.

As I understand, you are facing trouble in connection to PostgreSQL Server from Power Platform, Powerapps.

Please let us know if my understanding is different from your ask.

I assume you are using Power Apps "Premium" class account as PostgreSQL connector is available from Premium Class in all Power Apps regions except the following:

US Government (GCC High)

US Department of Defense (DoD).

Please make sure below prerequires meet:

PostgreSQL connector requires NPGSQL ADO.NET provider 4.0.10 to be installed. To install NPGSQL ADO.NET provider, go to release page and download the relevant release. The provider architecture (32-bit or 64-bit) needs to match the architecture of the product where you intent to use the connector. When installing, make sure that you select NpgSQL GAC Installation to ensure NpgSQL itself is added to your machine. The minimun supported PostgreSQL database version is version 9.4.

Reference link:

https://learn.microsoft.com/en-us/connectors/postgresql/

Note: Above reference is for PostgreSQL and in list of connectors, we do not have "Azure Database for PostgreSQL" https://learn.microsoft.com/en-us/connectors/connector-reference/ yet.

Let us know if this helps or you have a different issue.

Awaiting your reply, thanks.

Your answer

Mallaiah Sangi 95 Reputation points Microsoft External Staff

2025-03-13T04:20:09.8233333+00:00

Hi @Irvanda

Thanks for the Question and using Microsoft Q&A platform

As per my understanding, your facing connection issue for PostgreSQL flexible servers Via Power Apps.

If you're having trouble connecting PostgreSQL to Power Apps, here are a few steps you can try to troubleshoot the issue:

Ensure the Correct Connector: Power Apps doesn't have a native PostgreSQL connector. You need to use a third-party connector or a custom connector to connect to PostgreSQL. Check if you're using a reliable connector, such as the "PostgreSQL".

Check Connection Credentials: Double-check the credentials (username, password, host, port) you are using to connect. Make sure they are accurate and correspond to the PostgreSQL database instance you're trying to connect to.

Database Access: Ensure that your PostgreSQL server allows remote connections, if applicable. The server’s pg_hba.conf file should allow connections from your Power Apps IP address or domain. I hope, this response will address your query and helped you to overcome on your challenges. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Irvanda 116 Reputation points

2025-03-13T05:29:25.3833333+00:00

Hi @Mallaiah Sangi

Thanks for the answer.

In the "Ensure the Correct Connector" section, what do you mean by "third-party connector or a custom connector to connect to PostgreSQL."?

For "Check Connection Credentials", I made sure it was correct.

Then for "Database Access", PostgreSQL on Azure can actually be accessed from a local device. However, when accessed with Power Apps on a web browser, the error occurred.

I tried to simulate creating PostgreSQL on Google Cloud Platform and tried to set up a connection on Power Apps. The result was that it could connect without any problems.

Why does the problem only occur if Power Apps creates a connection to PostgreSQL on Azure? Is there anything else that needs to be ensured on PostgreSQL in Azure so that Power Apps can connect?
Mallaiah Sangi 95 Reputation points Microsoft External Staff

2025-03-13T07:12:17.0666667+00:00

Hi Irvanda

Thanks for your response.

Please find the documentation link. you will get more details connect to the PostgreSQL server via the following alternative tools:

psql – a terminal-based utility to connect to the PostgreSQL server.

pgAdmin – a web-based tool to connect to the PostgreSQL server. https://neon.tech/postgresql/postgresql-getting-started/connect-to-postgresql-database I hope, this response will address your query and helped you to overcome on your challenges.
ShaktiSingh-MSFT 16,251 Reputation points

2025-03-13T08:53:58.08+00:00

Hi Irvanda •

Welcome to Microsoft Q&A forum.

As I understand, you are facing trouble in connection to PostgreSQL Server from Power Platform, Powerapps.

Please let us know if my understanding is different from your ask.

I assume you are using Power Apps "Premium" class account as PostgreSQL connector is available from Premium Class in all Power Apps regions except the following:

US Government (GCC High)

US Department of Defense (DoD).

Please make sure below prerequires meet:

PostgreSQL connector requires NPGSQL ADO.NET provider 4.0.10 to be installed. To install NPGSQL ADO.NET provider, go to release page and download the relevant release. The provider architecture (32-bit or 64-bit) needs to match the architecture of the product where you intent to use the connector. When installing, make sure that you select NpgSQL GAC Installation to ensure NpgSQL itself is added to your machine. The minimun supported PostgreSQL database version is version 9.4.

Reference link:

https://learn.microsoft.com/en-us/connectors/postgresql/

Note: Above reference is for PostgreSQL and in list of connectors, we do not have "Azure Database for PostgreSQL" https://learn.microsoft.com/en-us/connectors/connector-reference/ yet.

Let us know if this helps or you have a different issue.

Awaiting your reply, thanks.

Share via

PostgreSQL can't be connected by Power Apps

Your answer