Bad Gateway error occurs when publishing a Power Apps app that uses a SQL connection.

(0) Share

Report

Posted on by PB-20021225-0

Hi Everyone
I have created one power apps (Canvas app) that are publish and used by multiple users
Today suddenly multiple error are occurred and application are stopped working

I have also tried to get the application old version restored it but have same error

error like

Error when trying to retrieve data from the network: Resource not found

GetAllCalls.Get failed: { "error": { "code": 400, "message": "Error validating Execution Restrictions - Bad URL", "source": "msmanaged-na.azure-apim.net", "path": "choose[2]\\when[1]\\choose\\when[2]", "policyId": "", "clientRequestId": "d442ab1a-43d7-48db-ba01-82dc0db8558c", "dreeSet": "true" } }

This related some things like sql related things i used sql connection issue

Please help me with this.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Assisted by AI

pavanmanideep 576 Power Up Champ - 2025 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PB-20021225-0

Please try as below..

Step 1 — Test the SQL connection directly
Go to: Power Apps → Connections → SQL → Test Connection
If it fails:

Password changed

User disabled

Firewall issue

Step 2 — Recreate the SQL connection

This fixes 80% of cases.

Remove the SQL connection from the app

Remove the SQL connection from Power Apps

Create a new SQL connection

Re-add it to the app

Step 3 — Check SQL object names

Verify that:

The table/view/stored procedure still exists

The name is exactly the same

No schema changes happened (dbo → custom schema)

Step 4 — Check the gateway (if on‑prem SQL)
Go to: Power Platform Admin Center → Data → Gateways

Check:

Gateway is online

SQL server is reachable

Credentials are valid

Step 5 — Check SQL firewall (if Azure SQL)
In Azure Portal:
Open SQL Server

Firewall settings

Ensure “Allow Azure services” is ON

Ensure your region is allowed

Step 6 — Check if someone modified the SQL view or stored procedure
If you use:

Views

Stored procedures

Functions

Give a thumbs up if this helped you, and mark it as the answer if it solved your problem.

Hope this helps…

Cheers,
PMDY
Microsoft Business Applications MVP
Subscribe to my blog: https://ecellorscrm.com

Was this reply helpful? Yes No
CG-21051138-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

I had the same problem.
I'd created a new connection in PowerApps and connected the sp over this new connection (like Step 2 from @pavanmanideep). This worked.

Was this reply helpful? Yes No
pavanmanideep 576 Power Up Champ - 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

Give a thumbs up if this helped you, and mark it as the answer if it solved your problem.

Hope this helps the community find better answers…@CG-21051138-0

Cheers,
PMDY
Microsoft Business Applications MVP
Subscribe to my blog: https://ecellorscrm.com

Was this reply helpful? Yes No