Azure postgres connection to powerApps
My probleme is the postgre connector on powerApps doesnt allow to connect to an online server . Its mandatory to select a gateway and to create a gateway , but you have to do it in local (see the screenshot) ?
I create a gateway on the azure portal and it doesnt appaer on the select option in powerapps. The only gateway who appear are the one on my local computer.
How can I create a connction between powerApps to my Azure PostGre database ?
I have try to use the SQL dataBase connector which allow us to use a cloud server but that doesnt work easer because it said the server doesnt exist or isn't found .
The screenshot of Postgres connector in PowerApps
(reposting answer from MSDN Forums)
That is correct -- you need a Gateway to use the PostgreSQL connector today in PowerApps. The reason we need a Gateway is because we need the user to install the PostgreSQL client for the connector to work. We need some work to update our documentation to explain this requirement better. PostgreSQL client: https://github.com/npgsql/Npgsql/releases
To understand more on PowerApps Gateway requirements, you can see this article here: https://learn.microsoft.com/en-us/powerapps/gateway-management
This article explains the on-premise Gateway in detail: https://learn.microsoft.com/en-us/powerapps/gateway-reference
Also, for any PowerApps specific question, please feel free to leverage PowerApps community here: https://powerusers.microsoft.com/t5/PowerApps-Community/ct-p/PowerApps1
- dspace import metadata acknowledges changes doesn't apply them
- Running the Postgres CLI client from a Kubernetes jumpbox
- Problem Restoring PostgreSQL Database in Docker Container with Symfony
- Getting error recursive reference to query must not appear within its non-recursive term in postgres
- Postgres split time ranges into 1 minute slots, without rounding boundaries
- how to store PostgreSQL jsonb using SpringBoot + JPA?
- How to write this SQL query to find each account balance?
- Filter out rows in 1:N LEFT JOIN where any row in child table fails condition
- SQL Formatting a string (name)
- Postgres Query using concat and LIKE
- Autoincrement separately for each foreign key
- error connecting external database with rails
- Forward fill NULL values in multiple columns
- PostgreSQL EXISTS in user-defined function always returning true
- Problem with creating server in pgadmin 4, unable to connect to server
- Oracle JSON_TABLE to PostgreSQL - how to search from the second hierarchical key in a JSON column
- pg_upgrade on Windows cannot write to log file pg_upgrade_internal.log
- SQLAlchemy Many-to-Many using PostgreSQL's on_conflict_do_update doesn't get committed
- Why is my postgres constraint name suffix different from the standard?
- I want to restore the database with a different schema
- Postgres settings to maximize compute resources for a single local connection
- Why does an operation on real and a numeric inputs result in a double precision?
- Typeorm queryBuilder select only a specific key value of a JSONB type column
- How to set `lock_timeout` on a PostgreSQL connection with SQLAlchemy and psycopg2?
- How to calculate DATE Difference in PostgreSQL?
- Missing FROM-clause entry for a table
- PostgreSQL 17: pg_upgrade on Windows Server 2019: could not load library "$libdir/adminpack": No such file or directory
- Displaying binary images on JSP page
- Recursive CTE in Postgresql
- Add missing dates in a table