Implement row level security so that everyone can see the reports data

[jatneerjat]

Hi,

I have a report in which i have created a role as "UserEmail = userprincipalname()"  and added a security group in which there are multiple users so any user logged in will see only his data.

Now  there is another admin group which can see all data so how can I create the role in same report so that users from one group can see only info related to them and other groups(admin) user can see all info on the report.

Currently whenever a user who have not added to any role logged into power bi service(Already have access to the report) then the report appeared as below.Why the user not able to see the visuals?

When I click on 'See details'

Thanks,

Jat

[Anonymous]

@jatneerjat,

When you configure RLS in your dataset, the users should be added as role members in Power BI Service, otherwise, they are unable to view reports. This is by design.

Regards,
Lydia

[jatneerjat]

Hi @Anonymous,

So how to create a role so that if i added a group in to this role then everyone from the group can see all the data in reports.

I tried creating [ID] <> "" but it doesnt work.

Thanks

[Anonymous · Accepted solution]

@jatneerjat,

You can create a new role using DAX:1=1 in Power BI Desktop.

Regards,
Lydia

[nerra]

@Anonymous hi. can you elaborate a bit on the Dax 1=1?

[jatneerjat]

Thank you @Anonymous.It works.