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

Hello all think, i have solutions.

Try this:

• Log in to the Entra ID portal: Go to the Entra ID portal and log in to your account with the appropriate permissions (Application Administrator or Global Administrator)
• Find your enterprise application: In the menu on the left, select "Enterprise applications" and find the application for which you want to add a delegated entitlement. You must search this: Application 'f3b07414-6bf4-46e6-b63f-56941f3f4128'

My sample error log

"message":"AADSTS7000113: Application 'f3b07414-6bf4-46e6-b63f-56941f3f4128' is not authorized to make application on-behalf-of calls. Trace ID: 99fafe84-cc0b-4fce-97a1-8875b9986d00 Correlation ID: 6d29d354-d4c2-46c1-b7e8-01bbee7873a5 Timestamp: 2024-11-12 14:22:20Z","resultType":"Exception"}}

• Go to Users and groups and add permissions for the group or user who created the flow.

Enjoy