Forum Discussion

alex's avatar
alex
Helper I
8 years ago
Solved

access_denied: AADSTS65005: The application 'Microsoft Power Query for Excel' asked for scope 'user_

EDIT: this seems to be an O365 issue, I'm also having this problem.....     I have a user that's getting the below error when trying to run a Power Query refresh to pull data from a shared mailbox...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    RedAngle alex Anonymous sysadm01 Frelis69,

    I got response from PG:

    "this issue has been mitigated by the O365 team by relaxing their login restrictions."

    Regards,
    Lydia

RedAngle's avatar
RedAngle
Frequent Visitor
8 years ago

Update - when I look at the Azure AD admin portal, I can see an authentication failure when I try to connect to the Office 365 mailbox from Power BI. The source application is 'Microsoft Power Query for Excel' (as expected).

 

The failure reason is listed as:

The application required resource access list does not contain applications discoverable by the resource or The client application has requested access to resource, which was not specified in its required resource access list or Graph service returned bad request or resource not found. If the application supports SAML, you may have configured the application with the wrong Identifier (Entity). Try out the resolution listed for SAML using the link below: https://docs.microsoft.com/azure/active-directory/application-sign-in-problem-federated-sso-gallery?/?WT.mc_id=DMC_AAD_Manage_Apps_Troubleshooting_Nav#no-resource-in-requiredresourceaccess-list.

 

I am not running the very latest version of Power BI (I'm one version behind) so will update and see if that resolves the issue, but I don't expect it to.

 

sysadm01's avatar
sysadm01
Frequent Visitor
8 years ago

Hi everybody!

Try to disable Power Query add-in, restart Excel and re-enable the add-in.

This worked for me.

Cheers!