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

Question

All my Transform Data Using Power Query steps in my flows are receiving the following message after Friday afternoon. I had some successful runs before that, perhaps 30 minutes prior.

The error I am receiving is the following:

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

Is this perhaps a limit exceeded? Is there anyway to find out or diagnose this?

I double checked with IT and I have user access to the On-prep gateway that the SQL server works with.

Answer 1

This might be connected to how the new flow builder works. Using the old builder, I can open the power query editor and can see data queried from the database (still won't work tough).

Using the new builder however, I get an error after typing in the SQL query:

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" } }

Power platform community thread: https://community.powerplatform.com/forums/thread/details/?threadid=66a0da9c-9e9f-ef11-8a69-6045bdee0f9b

Answer 2

Please write in your answers if you use the old or new builder. I am ONLY using the old builder, because of the exact same issue. as described by @Szabolcs Kelemen

I have never been able to use the new one; in fact, last time I tried, my flow got broken when I saved. I'm not 100% sure what exactly got broken (cant remember), but something tells me that it was the queries in 'Transform Data using Power Query', or something with the connector.

Answer 3

I have just had the same issue. 1 of my flows no longer works and ials I try to make adjustments I can't save it.

When I try a new one I can't save the flow anymore.

It occurs in the old editor and only at ‘Transform Data using Power Query’

For your information: You can't use this in the new editor.

Hopefully a solution soon

Answer 4

Exactly the same issue that I experience. Have been running the same flows 4 times daily for a year, but today they stopped working throwing 'Application 'f3b07414-6bf4-46e6-b63f-56941f3f4128' is not authorized to make application on-behalf-of calls'.

Using the old flow editor. The query works fine in the Power Query editor. However trying to save also throws a huge exception...

Answer 5

I can confirm that MS fixed the issue. Previously failing flows work again. (Saving flows with the power query step also works.)