Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Transform Data Using Power Query AADSTS65001 issue

(4) ShareShare
ReportReport
Posted on by 22

Hi everyone and thanks for your time reading my post.

Last Friday when I tried to using the connector "Transform Data Using Power Query" in my flow and create a new query, the error code AADSTS65001 pop out. After a few hours of troubleshooting the problem is unable to resolve. On the next day, the "Transform Data Using Power Query" connector works again without error. But starting from 16/08/2022, the same error occurs again and until now the error is still appear every time I press "Create Query" and "Edit Query". 

 

The content of the error code AADSTS65001 is 

The user or administrator has not consented to use the application with ID 'xxxxx-xxx-xxx' named 'Microsoft Flow Portal'. Send an interactive authorization request for this user and resource.

 My admin did not make any changes on his side until today because this connector is working smoothly since 4 months ago. This is the first time I encounter this type of errors.

 

I would really appreciate for the help if anyone can help me resolve this issue.

Thanks again for your time.

  • tmollGKA Profile Picture
    tmollGKA 3 on at
    Re: Transform Data Using Power Query AADSTS65001 issue

    I was able to use this as a workaround, however do we have an ETA for an actual fix? I don't see anything in the status page for an issue like this. Very frustrating!

  • JunHuiYip Profile Picture
    JunHuiYip 22 on at
    Re: Transform Data Using Power Query AADSTS65001 issue

    Thank you for the link. The Power Query connector is now working using that workaround.

  • PrzemyslawZdune Profile Picture
    PrzemyslawZdune 20 on at
    Re: Transform Data Using Power Query AADSTS65001 issue

    Great! It works for me as well! Thank you!

  • gpohlod Profile Picture
    gpohlod 38 on at
    Re: Transform Data Using Power Query AADSTS65001 issue

    Thank you for this, working here too! hopefully they don't disable the flag until they fix the bug!

     

    gpohlod_0-1661205707573.png

     

  • brandonl_pr Profile Picture
    brandonl_pr 15 on at
    Re: Transform Data Using Power Query AADSTS65001 issue

    Sure enough, this works!  Thanks for the workaround.

  • Verified answer
    mrdamgoode Profile Picture
    mrdamgoode 75 on at
    Re: Transform Data Using Power Query AADSTS65001 issue

    Hey gang, 

    I got a workaround from Tech Support.  This has something to do with the switch to make.powerautomate.com.

    Use the following link to get to Flow, ignore the warning at the top about redirects, then open or create your flow from that landing page.

    https://flow.microsoft.com/?EnableMakerShellPortalRedirect=false

     

    I can confirm, that I am able to edit my power queries by following that link.

     

    Godspeed Automators!

  • brandonl_pr Profile Picture
    brandonl_pr 15 on at
    Re: Transform Data Using Power Query AADSTS65001 issue

    The response I received from Microsoft is the following:

     

    I escalated the issue internally and got a feedback that admin consent is required to be grant through Azure. Here is an article explaining the step by step to grant admin consent:

    Fixed – AADSTS65001: The user or administrator has not consented to use the application with ID – Nishant Rana's Weblog

     

    These steps did not resolve the issue.  My settings were already configured as this document indicates.  If someone else has luck using this solution, please let me know.  I have responded to my ticket letting them know this didn't work.

  • brandonl_pr Profile Picture
    brandonl_pr 15 on at
    Re: Transform Data Using Power Query AADSTS65001 issue

    I'm experiencing this same issue since 8/16/2022.  I opened a ticket with Microsoft support on 8/17/2022.  Currently awaiting a response from their investigation.  I linked them this post to show that it's not just a localized issue to a single person/environment.

     

    I agree with @JunHuiYip that this is not a minor issue.  90% of the automated flows we create utilize this particular connector.  We are currently stuck; not being able to edit & create the "Transform Data Using Power Query" connector.

     

  • JunHuiYip Profile Picture
    JunHuiYip 22 on at
    Re: Transform Data Using Power Query AADSTS65001 issue

    Great, I hope the support understand this is not a minor issue and take action to resolve the issue ASAP.

    Thanks again.

     

  • arijafari Profile Picture
    arijafari 18 on at
    Re: Transform Data Using Power Query AADSTS65001 issue

    I have the same problem, I cannot edit any steps contained in the flows that refer to Power Query Sql

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics