Power Platform Community Forum Thread Details

Hello,

We are trying to use the new feature to call a SQL stored procedure directly in Power Apps via a SQL connector.

This works fine while designing the app but when you try to go in in "Play/Run Mode" it throws the following errors:

<DBName>.<StoredProcedureName> failed: { "error": { "code": 403, "message": "Procedure dbo.<StoredProcedureName> is not allowed", "source": "unitedstates-002.azure-apim.net", "path": "choose[3]\\when[1]\\choose\\when[2]", "policyId": "", "clientRequestId": "ea5b5d15-0681-4f7e-8571-34de302aad9e" } }