Search code examples
azureazure-active-directoryazure-synapse

Failed to list resources error, when adding a new user to Azure Synapse Analytics Workspace


I am trying to add users to my synapse workspace and getting a 'Failed to list resources' error. I have 'Synapse Administrator' role privileges. Please help.

Image of error


Solution

  • I think the issue is related to not having enough permissions in the Azure Entra (a.k.a. Azure AD) tenant/directory to search for other users. For example, this happens when you are a guest in an Azure Entra tenant instead of being a full member of the tenant (source). You should be able to get around that issue by:

    1. adding the missing permissions in Azure Entra,

    2. OR adding the user by their user ID (GUID for that user).

    For example, I see the same error that you get on one of my Synapse workspaces. I'm a guest on the tenant for that workspace. This is what I get when I try to add the user by name or email:

    I cannot add user by name or email

    However, I have no problems adding the user by their user ID (GUID for that user):

    I can add user by user id