Forum Discussion
Super UserRLS - Custom message for no access
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/
Community ChampionHi,
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/
Do you know if such approach works on the Power BI Report Server?
Because I cannot seem to make it work, otherwise, it works fine on the Desktop Power Bi app.- ValtteriN
Hi,
Dax should work normally, but there is a slight difference in RLS check this article for more details:
Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Learn
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?
