Share via

Power Automate: SQL - Transform data using Power Query action not working.

Anuar 86 Reputation points
2022-07-26T11:47:01.967+00:00

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.

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,

Azure SQL Database
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
38,599 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 33,611 Reputation points MVP
    2022-07-26T12:24:53.153+00:00

    Let me know if the options provided here help you fix the issue.

    Try also to post your question on this specific forum as Power Apps/Power Automate are not supported on Mirosoft QA. You may get better answers on that forum.

    0 comments
  2. Anuar 86 Reputation points
    2022-07-26T15:00:01.3+00:00

    Hi Alberto,

    Thank you for the quick response. I looked at the documentation you provided and follow the steps, this however doesn't seem to be a autorisation issue.

    Thank you for pointing me in the right direction, I cross-posted my question too the right forum :)

    Best regards,

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.