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 appli...
Need Help
  • 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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

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.