Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Revoke RLS for a specific page

Hi, I have my pbix with RLS implements based on the heirarchy of the organisation. The report has 6 tabs and the RLS is applied on all 6 tabs currently. However I need to know if I can ignore this ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    v-diye-msftI thought of it but I require my users to export the underlying data as well. Anyways I have followed the similar approach but replicated the entire table ( 3 tables in my case). Marking this comment as a solution. 

    Greg_Deckler  Please see the above.

     

v-diye-msft's avatar
v-diye-msft
Community Support
5 years ago

Hi Anonymous 

 

Typically the way I have worked around this issue is creating a summarization table within the model. This table is disconnected from any tables that have RLS applied. By doing this, users can see summarized data but not the underlying data that comprises those aggregations.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    v-diye-msftI thought of it but I require my users to export the underlying data as well. Anyways I have followed the similar approach but replicated the entire table ( 3 tables in my case). Marking this comment as a solution. 

    Greg_Deckler  Please see the above.