Forum Discussion

terjefjeldstad's avatar
terjefjeldstad
Icon for Advocate II rankAdvocate II
11 months ago

Not able to add description to security roles.

It would be great to add further description to security roles in a semantic model in Power BI Desktop. I see that the field is available in TMSCHEMA_ROLES. By adding this to a solution, non-technical personnel could get a more "user-friendly" explanation of the different roles added. It would also add more value to self-documentation solutions.

3 Replies

  • Hi terjefjeldstad ,

     

    You've raised an excellent point about a well-known limitation within the Power BI Desktop interface. It is correct that while the underlying Tabular model schema, specifically TMSCHEMA_ROLES, supports a description field for security roles, the Power BI Desktop user interface does not provide a direct way to edit this information. This is a classic example of the Power BI front-end not fully exposing all the capabilities of the powerful Analysis Services engine that it runs on.

     

    The most effective workaround for this is to use an external tool called Tabular Editor. This tool allows you to connect directly to your Power BI model's data structure and modify properties that are otherwise hidden in the standard interface. To do this, you would first need to install Tabular Editor and add it to the "External Tools" ribbon in Power BI Desktop. Once it is set up, you can launch Tabular Editor from your PBIX file, navigate to the "Roles" folder in its explorer pane, and select the specific role you wish to modify. In the properties pane, you will find the "Description" field where you can input your user-friendly explanation. After entering the description, you simply save the changes in Tabular Editor, which writes the metadata directly back to your Power BI file.

     

    Adding these descriptions is, as you mentioned, incredibly valuable for self-documentation and for making the data model more understandable for non-technical personnel. It serves as a crucial bridge between the technical implementation and the business logic the roles are meant to represent. This functionality has been a long-standing feature request from the Power BI community, and you can contribute by voting for this idea on the official Microsoft Fabric Ideas forum, as a higher number of votes increases the likelihood of it being included in a future update.

    Best regards,

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi terjefjeldstad,
    Thanks to tayloramy , DataNinja777    for those inputs on this thread. 

    Can you please confirm whether you have raised it in Ideas forum, Please note that Microsoft regularly reviews ideas shared by the community, and your suggestion may be considered for future updates.

    Thank you once again, and we encourage you to continue engaging with the Microsoft Fabric Community.


    Best regards,

    Community Support Team.