Role Membership Not Reflecting in Power BI Workspace

[lorcan17]

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 'user@example.com' = user
    member 'adgroup' = group

Problem
When I sync with my Power BI workspace, neither user@example.com 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

[lorcan17]

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

[jfeliubadalo]

Hi @lorcan17 

Did you manage to solve this issue ?

[Anonymous]

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]

Hi @Anonymous ,

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