Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.