Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vivien57
Helper II
Helper II

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 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

1 ACCEPTED SOLUTION
ValtteriN
Super User
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:
ValtteriN_0-1669889940175.png

When viewing with enough rights the message is blank:

ValtteriN_1-1669890032712.png

 


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/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ValtteriN
Super User
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:
ValtteriN_0-1669889940175.png

When viewing with enough rights the message is blank:

ValtteriN_1-1669890032712.png

 


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/





Did I answer your question? Mark my post as a solution!

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors