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?

Jorge L Dominguez 46 Reputation points
2024-01-14T23:44:07.9166667+00:00

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"
        },
"
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
456 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Bhargava-MSFT 31,116 Reputation points Microsoft Employee
    2024-01-16T20:52:41.3733333+00:00

    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.

    User's image

    User's image

    I hope this clarifies.

    Please let me know if you have any further questions.

    0 comments No comments

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.