Forum Discussion

lorcan17's avatar
lorcan17
Frequent Visitor
1 year ago

Role Membership Not Reflecting in Power BI Workspace

Hi Team,

I’m encountering an issue with role-based security in my dataset using TMDL. Specifically, I’m having trouble with the member option when defining roles.

Here is the TMDL snippet I am using:

role Admin
    modelPermission: read

    member '[email protected]' = user
    member 'adgroup' = group
 

Problem
When I sync with my Power BI workspace, neither [email protected] nor the adgroup appears when I view the security settings. The expected behavior is that these roles should be visible and correctly applied to the users/groups specified.

Additional Information
Documentation Reference: TMDL Role Members

Request
Could you please assist in giving clarity to the purpose of the member option in the role.tmdl file? Is it meant to be used in this way? It seems like there might be a sync or configuration problem, but I would appreciate any insights or suggestions.

Thank you!
Lorcan

 
Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, lorcan17 

    Here's what I've found so far about your question, which I hope you find helpful:

    1.First of all, about your first question, the member options in the role. TMDL files are used to specify users or groups that should be assigned to a specific role. This allows you to define who has access to specific data or features in your Power BI dataset.

     

    Here's a brief overview of its purpose:

    User assignment: You can assign individual users to roles by specifying their email addresses.

    Group assignments: You can assign security groups to roles, which is useful for managing permissions for multiple users at the same time.

    Here is a screenshot of the relevant documentation:

    Tabular Model Definition Language (TMDL) | Microsoft Learn
     

    2.Then, as you said, this can be a transient issue, and sometimes, changes in the TMDL file may not sync properly with the Power BI service. Try re-uploading the dataset or refreshing the workspace to see if the changes take effect.

     

    3.Finally, make sure that the syntax and formatting of the TMDL file is correct. For example, make sure there are no extra spaces or incorrect characters.

    Tabular Model Definition Language (TMDL) | Microsoft Learn
     
    Of course, if you have any new ideas, you are welcome to contact us.
     

    Best Regards,

    Leroy Lu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • jfeliubadalo's avatar
      jfeliubadalo
      Regular Visitor
      1 year ago

      Hi Anonymous ,

      Could you please provide a wider explanation about the solution you gave?

  • lorcan17's avatar
    lorcan17
    Frequent Visitor
    1 year ago

    Hey - yes familiar with the documentation. 

     

    My question is in relation to whether this feature of tmdl is expected to work in conjunction with Power BI Git Integration. 

    When I make changes to RLS on service I don't see any 'changes' to my model. Likewise when I deploy the TMDL adding the 'member' field, I don't see the groups reflected on the dataset.

    Please note, if it was a spacing error, I woul get an error message which I do not.

     

    Thanks