Transform Data Using Power Query AADSTS65001 issue

[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.

[PrzemyslawZdune]

I have the same issue

[gpohlod]

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.

[arijafari]

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

[JunHuiYip]

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

Thanks again.

[brandonl_pr]

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.

[brandonl_pr]

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 – Ni...

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.

[mrdamgoode · Accepted solution]

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]

Sure enough, this works!  Thanks for the workaround.

[gpohlod]

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

[PrzemyslawZdune]

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

[JunHuiYip]

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

[tmollGKA]

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!