We have created a very simple Power automate cloud flow which uses PostgresSQL.
The PostgresSQL gets connected via. an OnPremise Data Gateway and work quiet well on the DEV environment.
We are even able to retreive the data using different uses.
But when we import the solution in our STAGE environment the same fails while recreating the connection.
Both the environments use the same DLP and are placed in same region & have same security setup.
The on-premise data gateway used is also same and so is the Postgres SQL being connected.
But still we get the error stating
Also, when we tried the same credentials to create a additional connection in the DEV environment the 'create connection' fails with the same error as above.
I tried to check some logs in the gateway and can see failures with the same error.
So can someone direct us in a appropriate direction to further analyze / debug & resolve this issue ?
Issue was not related to Power Platform / Data Gateway but Postgres SQL.
By using the correct service setting I was able to get this issue resolved.
Was this reply helpful?YesNo
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.
27
Share
Report
All responses (
Answers (
