Unanswered

SQL - Transform Data Using Power Query receiving errors all of a sudden in all of my flows.

(5) Share

Report

Posted on by Waqar Qureshi

I am receiving the following message as an output from my Transform Data Using Power Query steps:

AADSTS7000113: Application 'f3b07414-6bf4-46e6-b63f-56941f3f4128' is not authorized to make application on-behalf-of calls. Trace ID: 27abcedf-d2b9-4f61-a2e3-aecccd0be601 Correlation ID: fa72225e-8007-4254-818c-60484c37d060 Timestamp: 2024-11-10 19:31:50Z

They were working just fine before noon on Friday, but seems like they just stopped working.

I initially thought it was a limit I was hitting a limit but I'm not sure if there's anyway to diagnose that or see this as I'm not reading anything in the output to suggest that.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

szabkel 17 on at

Like (0)

Report
SQL - Transform Data Using Power Query receiving errors all of a sudden in all of my flows.

Same thing is happening to me. Weird errors using the "Transform data using Power Query" step. Editor (the new editor) even fails on new empty flows with
Failed to retrieve dynamic outputs. As a result, this operation's outputs might not be visible in subsequent actions. Error details: The dynamic operation request to API 'sql' operation 'SqlGetPassThroughPQMetadata' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "error": { "code": 400, "message": "Error while processing request body: Unexpected character encountered while parsing value: s. Path '', line 0, position 0.", "source": "default-b42.....01.common.europe002.azure-apihub.net", "path": "choose[10]\\when[1]", "policyId": "", "clientRequestId": "b7...", "dreeSet": "true" } }

The old editor can open the power query editor and shows data from the database, but doesn't work when the flow is running.

Was this reply helpful? Yes No
moutinhoabreu 170 on at

Like (0)

Report
SQL - Transform Data Using Power Query receiving errors all of a sudden in all of my flows.

Same issue here.

all my flows with transform data query stopped work with similar error.

sql on premises

On step connections the sql is only available on section other connections. Weird

flow have been working for over 2/3 years

some of them are shared flows

Was this reply helpful? Yes No
jsierkstra 5 on at

Like (0)

Report

SQL - Transform Data Using Power Query receiving errors all of a sudden in all of my flows.

We have the same problem. Flows that have been working for +1 years, have suddenly stopped working due to: AADSTS7000113: Application 'f3b07414-6bf4-46e6-b63f-56941f3f4128' is not authorized to make application on-behalf-of calls.

Was this reply helpful? Yes No
pibobo 3 on at

Like (0)

Report

SQL - Transform Data Using Power Query receiving errors all of a sudden in all of my flows.

I have the same issue.

Flows with Transform Data Using Power Query stopped working. Looks like a global problem, can't find any fix.

Was this reply helpful? Yes No
datamanagement 3 on at

Like (0)

Report

SQL - Transform Data Using Power Query receiving errors all of a sudden in all of my flows.

We're having the same issues. Any solutions yet?

Kind regards

Was this reply helpful? Yes No
moutinhoabreu 170 on at

Like (0)

Report
SQL - Transform Data Using Power Query receiving errors all of a sudden in all of my flows.

Tried some fixes without succes:

Created a new SQL connection using "Windows Autentication Method".

Created a new Flow using this connection on Transform data using Power Query.

Restarted On-Prem-Gateway on server side with login.

No success result, same error on saving flow

Was this reply helpful? Yes No
OS-08100510-0 2 on at

Like (0)

Report

SQL - Transform Data Using Power Query receiving errors all of a sudden in all of my flows.

I have the same issue.

there is a thread on learn also:

Power Automate: SQL - Transform Data using Power Query recently started giving AADSTS7000113: Application 'f3b07414-6bf4-46e6-b63f-56941f3f4128' is not authorized to make application on-behalf-of calls error - Microsoft Q&A

Was this reply helpful? Yes No