SQL: Transform data using Power Query action not working.

(3) Share

Report

Posted on by Anuar1

Hello!

When attempting to use the Power Automate action: Transform data using Power Query, I get the following error:

AADSTS65001: The user or administrator has not consented to use the application with ID '6204c1d1-4712-4c46-a7d9-3ed63d992682' named 'Microsoft Flow Portal'. Send an interactive authorization request for this user and resource.

What folllows is a sign-in screen that results in a white screen which is endlessly displaying "loading

I looked at the Microsoft Flow Portal app in the Azure Portal, and there is no option too grant either user or admin consent as it is not needed. Has anyone experienced this issue before?

Thanks in advance for any help!

Best regards,

Categories:

Using connectors

I have the same question (0)

All responses (33)

Answers (0)

Martin87 7 on at

Like (0)

Report
Copy link

Link copied!

Hi, I had the same problem, I'm a new user. Try using the Microsoft Edge browser, I get the same error when a use Chrome but when I access with Edge it works fine. Hope it works for you too

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I have noticed this also that when you use other browser either than edge or internet explorer such happens. I guess try to use Microsoft browsers

Was this reply helpful? Yes No
NickWarner 113 on at

Like (1)

Report
Copy link

Link copied!

also getting this error. doesn't work on Chrome or Edge and occurs on all accounts i have access to.

Was this reply helpful? Yes No
PrzemyslawZdune 20 on at

Like (1)

Report
Copy link

Link copied!

I have the same issue

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Same issue

Was this reply helpful? Yes No
Martin87 7 on at

Like (0)

Report
Copy link

Link copied!

Edit: I'm now having the same error on Edge.

Was this reply helpful? Yes No
gpohlod 38 on at

Like (0)

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
vissvess 64 on at

Like (0)

Report
Copy link

Link copied!

Same issue for years: Flow: Transform data using power query does not wo... - Power Platform Community (microsoft.com). Now I am stuck with this.
Upon support ticket creation, the response from Microsoft is like - 'This is a known bug and team are working on it; and then requesting consent to close the ticket.'

Was this reply helpful? Yes No
arijafari 18 on at

Like (1)

Report
Copy link

Link copied!

I have the same issue, it's really important!

Was this reply helpful? Yes No
takolota1 4,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

What are the use-cases for this?

Are some of you trying to use Power Query to transform data into large batch SQL queries? Because I did recently create a template for such things:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/SQL-Batch-Create-Read-Update-and-Delete/td-p/1715338

Was this reply helpful? Yes No