Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 at the highest level of granularity, however, during a drill-through, to see the detail, some users will not be able to see the data. When this is the case they see an empty table.
Is it possible to display a custom message, to tell them that they don't have the rights?
Otherwise they may think there is a problem and that no data is displayed.
Thanks in advance for your feedback,
Have a nice day,
Vivien
Solved! Go to Solution.
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/
Proud to be a Super User!
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/
Proud to be a Super User!
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |