Power Platform Community Forum Thread Details

Hi,

I have a number of flows that use a power query to query an SQL server through a gateway.

Suddenly I'm getting the error below. ChatGPT points me towards a permission error in Azure, but the app isnt listed as an app in Azure (never has been). Does anyone have experiance of this problem that could point me in the right direction?

{
"statusCode": 200,
"headers": {
"Cache-Control": "no-cache",
"Vary": "Accept-Encoding",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"Content-Security-Policy": "default-src 'self'; child-src 'none'; manifest-src 'none'; media-src 'none'; object-src 'none'; connect-src https:; img-src 'self' https://p.sfx.ms data:; style-src 'self' 'unsafe-inline'; frame-src *; frame-ancestors 'self' https://adf.azure.com https://ms-adf.azure.com https://pbiadx.powerbi.com https://*.consent.dynamics.com https://*.ci.ai.dynamics.com https://*.api.ci.ai.dynamics.com https://msit.powerbi.com https://app.powerbi.com https://www.powerbi.com https://admin.powerplatform.microsoft.com https://dataintegrator.trafficmanager.net https://admin.powerapps.com https://admin.flow.microsoft.com https://*.admin.powerapps.com https://*.admin.flow.microsoft.com https://*.businessplatform.microsoft.com https://*.officeapps.live.com https://*.optin.online.office.com https://make.powerautomate.com https://*.insightsplatform.microsoft.com https://dataflow-templates.dap.microsoft.com https://pbifxs.powerbi.com https://pbigql.powerbi.com https://*.crm4.dynamics.com https://*.iom.d365.dynamics.com https://powerqueryintegrationservice.*.gateway.prod.island.powerapps.com https://pbiriv.powerbi.com https://web.powerapps.com https://*.web.powerapps.com https://make.preprod.powerapps.com https://make.preview.powerapps.com https://make.powerapps.com https://www.office.com https://scuprodprv.www.office.com https://outlook.office365.com https://outlook-sdf.office365.com https://outlook.office.com https://outlook-sdf.office.com https://pbiwhs.powerbi.com https://paginated-reports.powerbi.com https://teams.microsoft.com https://teams.powerbi.com https://sci.preview.dynamics.com https://sci.dynamics.com https://windblade.preview.dynamics.com https://windblade.dynamics.com https://digitalsupplychain.preview.microsoft.com https://digitalsupplychain.microsoft.com https://*.sustainability.prod.powerapps.com https://web.azuresynapse.net https://ms.web.azuresynapse.net https://pbidbc.powerbi.com https://msitpbidfw.powerbi.com https://msit.fabric.microsoft.com https://pbidfw.powerbi.com https://app.fabric.microsoft.com https://fabric.microsoft.com https://msitpbifde.powerbi.com https://pbidfe.powerbi.com https://pbidpe.powerbi.com https://pbistm.powerbi.com; font-src 'self' https://static2.sharepointonline.com https://spoprod-a.akamaihd.net https://spoppe-b.azureedge.net; worker-src 'self';",
"x-ms-result-type": "Exception",
"X-Rate-Limit-Limit": "30s",
"X-Rate-Limit-Remaining": "82",
"X-Rate-Limit-Reset": "2024-11-12T13:26:18.5517946Z",
"Timing-Allow-Origin": "*",
"Server-Timing": "total;dur=420,route;desc=\"Evaluator/Evaluate\"",
"x-ms-connection-gateway-object-id": "74c7ef85-cbdf-4b33-ac5b-92ad25ed1525",
"x-ms-environment-id": "default-5b287273-a02e-4417-aa45-3ba7fd3bbd24",
"x-ms-tenant-id": "5b287273-a02e-4417-aa45-3ba7fd3bbd24",
"x-ms-dlp-re": "-|-|-",
"x-ms-dlp-gu": "-|-",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Tue, 12 Nov 2024 13:26:08 GMT",
"Content-Length": "3936",
"Content-Type": "application/json; charset=utf-8"
},
"body": {
"data": {
"AsyncFriendlyStackTrace": " at Microsoft.Identity.Client.OAuth2.OAuth2Client.ThrowServerException(HttpResponse response, RequestContext requestContext)\r\n at Microsoft.Identity.Client.OAuth2.OAuth2Client.CreateResponse[T](HttpResponse response, RequestContext requestContext)\r\n at async Microsoft.Identity.Client.OAuth2.OAuth2Client.ExecuteRequestAsync[](?)\r\n at async Microsoft.Identity.Client.OAuth2.TokenClient.SendHttpAndClearTelemetryAsync(?)\r\n at async Microsoft.Identity.Client.OAuth2.TokenClient.SendHttpAndClearTelemetryAsync(?)\r\n at async Microsoft.Identity.Client.OAuth2.TokenClient.SendTokenRequestAsync(?)\r\n at async Microsoft.Identity.Client.Internal.Requests.RequestBase.SendTokenRequestAsync(?)\r\n at async Microsoft.Identity.Client.Internal.Requests.OnBehalfOfRequest.FetchNewAccessTokenAsync(?)\r\n at async Microsoft.Identity.Client.Internal.Requests.OnBehalfOfRequest.ExecuteAsync(?)\r\n at async Microsoft.Identity.Client.Internal.Requests.RequestBase.<>c__DisplayClass11_1.<RunAsync>b__1(?)\r\n at async Microsoft.Identity.Client.Utils.StopwatchService.MeasureCodeBlockAsync(?)\r\n at async Microsoft.Identity.Client.Internal.Requests.RequestBase.RunAsync(?)\r\n at async Microsoft.Identity.Client.ApiConfig.Executors.ConfidentialClientExecutor.ExecuteAsync(?)\r\n at async Microsoft.Mashup.Web.Fabric.AccessTokenStatelessService.MsalAuthenticationProvider.<>c__DisplayClass11_0.<GetSerializedTokenCache>b__0(?) in F:\\dbs\\el\\appq\\src\\Product\\Fabric\\AccessTokenStatelessService\\MsalAuthenticationProvider.cs:line 202\r\n at async Microsoft.Mashup.Web.Diagnostics.ITracingServiceExtensions.ExecuteOperationWithSuccessFailedResult[](?) in F:\\dbs\\el\\appq\\src\\Product\\Diagnostics\\ITracingServiceExtensions.cs:line 88\r\n at Microsoft.ServiceFabric.Services.Remoting.V2.Builder.MethodDispatcherBase.<>c__DisplayClass8_0`1.<ContinueWithResult>b__0(Task`1 t)\r\n at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()\r\n at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)\r\n at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)\r\n at Microsoft.ServiceFabric.Services.Remoting.V2.Runtime.ServiceRemotingMessageDispatcher.<>c__DisplayClass14_0.<OnDispatch>b__0(Task`1 t)\r\n at Microsoft.ServiceFabric.Services.Remoting.V2.Runtime.ServiceRemotingMessageDispatcher.<>c__DisplayClass14_0.<OnDispatch>b__0(Task`1 t)\r\n at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()\r\n at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)\r\n at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)\r\n at async Microsoft.ServiceFabric.Services.Remoting.Runtime.ServiceRemotingCancellationHelper.DispatchRequest[](?)\r\n at async Microsoft.ServiceFabric.Services.Remoting.Runtime.ServiceRemotingCancellationHelper.DispatchRequest[](?)\r\n at async Microsoft.ServiceFabric.Services.Remoting.V2.Runtime.ServiceRemotingMessageDispatcher.HandleRequestResponseAsync(?)\r\n at async Microsoft.Mashup.Web.Fabric.Core.Remoting.ExceptionSerializingServiceRemotingMessageHandler.HandleRequestResponseAsync(?) in F:\\dbs\\el\\appq\\src\\Product\\Fabric\\Core\\Remoting\\ExceptionSerializingServiceRemotingMessageHandler.cs:line 42"
},
"errors": [],
"exceptionType": "Microsoft.Identity.Client.MsalServiceException",
"message": "AADSTS7000113: Application 'f3b07414-6bf4-46e6-b63f-56941f3f4128' is not authorized to make application on-behalf-of calls. Trace ID: 3a8786ae-9fa4-48c7-b4ba-d75e4445b200 Correlation ID: b51123ff-8db7-46de-9178-f8585f29758a Timestamp: 2024-11-12 13:26:09Z",
"resultType": "Exception"
}
}

Categories:

Error handling