Forum Discussion

vivien57's avatar
vivien57
Super User
3 years ago
Solved

RLS - Custom message for no access

Hello all, I would like to know if there is a way to customise an end-user message when a user cannot see the data because of the RLS. I would like to explain. Users see all the data a...
Message
RLS
Row-Level-Security
  • ValtteriN's avatar
    ValtteriN
    3 years ago

    Hi, 

    One way to approach this is to create this kind of measure:

    Measure 25 = if(ISBLANK(MAX('Table 6'[Value1])),"You don't have the access required",blank())

    Here I have set up a rls rule to table 6 and when user doesn't have rights to see the data the text in the message is displayed in KPI:

    When viewing with enough rights the message is blank:

     


    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

ValtteriN's avatar
ValtteriN
Community Champion
3 years ago

Hi, 

One way to approach this is to create this kind of measure:

Measure 25 = if(ISBLANK(MAX('Table 6'[Value1])),"You don't have the access required",blank())

Here I have set up a rls rule to table 6 and when user doesn't have rights to see the data the text in the message is displayed in KPI:

When viewing with enough rights the message is blank:

 


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Stalker1's avatar
Stalker1
Regular Visitor
2 years ago

For some reason, this does not work for me. The user with no access will instead see that default RLS message bar on top, nothing else in the report. What am I missing here?