Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to configure row level security

Hi,

 

I need to restrict data access in my power bi report. Following are the categories that I want to define:

1. Category 1 - Users should be able to access all data (no restrictions to be applied)

        1.1 the user email id is present in my back end dataset

         1.2 the user email id is not present in my back end dataset

       for both 1.1 and 1.2 the users should be able to view all data and access the dashboard

2.Category 2- Users should be able to access data relevant to them

 

For category 2 I have configures RLS using userprincipalname() dax and it is working fine.

How do I configure for category 1.

 

Thanks!

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    You can create a new role "all" set all table filter dax expression as true. Then set these users as "all" role.

     

    Best Regards,

    Jay

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    You can create a new role "all" set all table filter dax expression as true. Then set these users as "all" role.

     

    Best Regards,

    Jay

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Anonymous - I forget exactly if it is necessary but one way I have done this is to create a column in a table that is simply:

     

    Column = 1

     

    Then you set your DAX Role RLS rule to be Column = 1. Presto, people in that role can see everything.