Forum Discussion
RLS - 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/
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/
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.
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