Forum Discussion

jatneerjat's avatar
jatneerjat
Icon for Helper V rankHelper V
8 years ago
Solved

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

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

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    jatneerjat,

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

    Regards,
    Lydia

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      jatneerjat
      Icon for Helper V rankHelper V
      8 years ago

      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's avatar
        Anonymous
        Not applicable
        8 years ago

        jatneerjat,

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

        Regards,
        Lydia