Only the role Object ID is displayed in the tabular model's Role list, making it hard to understand the role name. Is there a way to fix this?

Question

The object ID is displayed in SSMS and Visual Studio. Both applications show the object ID instead of the more user-friendly name. It isn't easy to manage roles for a tabular model. Software versions:
Microsoft Visual Studio Professional version 16.11.33
SSMS: 19.2.56.2

Extract: here is a sample of how I see the user and group accounts in the role's membership.

Is there a way to fix this?

"
{
  "createOrReplace": {
    "object": {
      "database": "Model",
      "role": "Access"
    },
    "role": {
      "name": "Access",
      "modelPermission": "read",
      "members": [

        {
          "memberName": "obj:f4de6as2-0b1e-48d6-899d-9353a69e4584@94V845bc-692d-4309-9460-4da6cb8b9c15",
          "identityProvider": "AzureAD"
        },
        {
          "memberName": "obj:08be9v5q-685b-4d74-a354-af54cd0ed515@94V845bc-692d-4309-9460-4da6cb8b9c15",
          "identityProvider": "AzureAD"
        },
        {
          "memberName": "obj:dabe5x92-0be1-4bd3-a53d-14786a55aac4@94V845bc-692d-4309-9460-4da6cb8b9c15",
          "identityProvider": "AzureAD"
        },
"

Answer 1

Hello Jorge L Dominguez,

When adding a member to roles in Azure Analysis Services, it directly pulls the data from Azure Active Directory.

In Azure Active Directory, the display of user and group accounts can vary depending on the type of account and how it was created. For example, for apps and some groups, Azure Active Directory may display the member name as an object ID instead of the more user-friendly name. However, for all users, it displays the friendly name.

Unfortunately, you cannot change this behavior from SSMS or Visual Studio as the app ID is directly pulled from Azure Active Directory. If you want to display the more user-friendly name instead of the object ID, you may need to modify the settings in Azure Active Directory.

I hope this clarifies.

Please let me know if you have any further questions.