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!
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
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.'
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:
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.
I can confirm, that I am able to edit my power queries by following that link.