Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month
News and Announcements icon
Power Platform Community / Forums / Power Automate - Building Flows / SQL - Transform Data U...
Power Automate - Building Flows
Unanswered

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

(5) ShareShare
ReportReport
Posted on by WQ-10111957-0 10
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:
Business Process Flows
  • OS-08100510-0 Profile Picture
    OS-08100510-0 2 on at
    SQL - Transform Data Using Power Query receiving errors all of a sudden in all of my flows.
  • moutinhoabreu Profile Picture
    moutinhoabreu 170 on at
    SQL - Transform Data Using Power Query receiving errors all of a sudden in all of my flows.
    Tried some fixes without succes:
     
    1. Created a new SQL connection using "Windows Autentication Method".
    2. Created a new Flow using this connection on Transform data using Power Query.
    3. Restarted On-Prem-Gateway on server side with login.
    No success result, same error on saving flow
  • datamanagement Profile Picture
    datamanagement 3 on at
    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
  • pibobo Profile Picture
    pibobo 3 on at
    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.
  • jsierkstra Profile Picture
    jsierkstra 5 on at
    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.
  • moutinhoabreu Profile Picture
    moutinhoabreu 170 on at
    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
  • szabkel Profile Picture
    szabkel 17 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans