Forum Discussion
RLS issue in the application
- 2 years ago
Then you can follow this approach:
Create Separate RLS Roles:
Project Manager Role: For conditional access.
Full Access Role: For full access.
DAX for Project Manager Role:
[Column1] = USERPRINCIPALNAME() ||[Column2] = USERPRINCIPALNAME() ||
[Column3] = USERPRINCIPALNAME() ||
[Column4] = USERPRINCIPALNAME()
DAX for Full Access Role:TRUE()
Implementation Steps:
Create Roles in Power BI Desktop:
Go to "Modeling" -> "Manage Roles".
Create "Project Manager" role with the DAX filter for limited access.
Create "Full Access" role with TRUE() DAX filter.
Publish the Dataset: Publish the dataset to the Power BI service.
Assign Users to Roles in Power BI Service: Under "Security" for the dataset, assign users to the appropriate roles.
Configure Report Access in Power BI App:
In the app, configure access:
For Report 1, assign the AD groups to "Project Manager" role.
For Reports 2, 3, and 4, assign specific people to "Full Access" role.If my post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Need more clarification.
Column1, Column2, Column3, Column4 have only the the email address of the people? Do you have a designation column other than email address of the people?
- Marco2332 years agoFrequent Visitor
Yes, all columns only contain email addresses of people and this is the only condition in the 'Project Manager' RLS rule.