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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
vivien57
Advocate V
Advocate V

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

4 REPLIES 4
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!




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?

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.