Answered

Transform Data Using Power Query AADSTS65001 issue

(4) Share

Report

Posted on by JunHuiYip

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.

Categories:

Using connectors

I have the same question (0)

All responses (12)

Answers (1)

PrzemyslawZdune 20 on at

Like (0)

Report
Copy link

Link copied!

I have the same issue

Was this reply helpful? Yes No
gpohlod 38 on at

Like (1)

Report
Copy link

Link copied!

Same Issue on all flows that have this in place and all new flows when trying it, we have a ticket in with Microsoft Support.

Was this reply helpful? Yes No
arijafari 18 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
JunHuiYip 22 on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
brandonl_pr 15 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
brandonl_pr 15 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

mrdamgoode 75 on at

Like (3)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
brandonl_pr 15 on at

Like (2)

Report
Copy link

Link copied!

Sure enough, this works! Thanks for the workaround.

Was this reply helpful? Yes No
gpohlod 38 on at

Like (3)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
PrzemyslawZdune 20 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No