Handling Row Level Security

[chotu27]

Hi,

I build row level security in power bi which is working fine as i expected.

But i wanted to display text field when someone  tries to access the report and his data is not available as "Your Information is not available"

[v-kelly-msft · Accepted solution]

Hi @chotu27 ,

I have a solution for you,see below:

First manage roles as below:

Then create a measure as below:

Measure = IF(SELECTEDVALUE('Table'[Column1])=BLANK(),"Your Information is not available",MAX('Table'[Column1]))

And you will see:

For the related .pbix file,you may see attached.

Best Regards,
Kelly

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

[collinq]

Hi @chotu27 ,

I think that this is a good idea, but if a person can't see data, I would think that a message more similar to "Your permissions do not let you see this data" would be more effective.  That is because the message "Your information is not available" would make me think that there is a report problem, a Power BI problem or perhaps even a data source problem.  

I would suggest that you make an idea and post the link to it here as I would definitely vote for a message that said RLS was limiting a users ability to see a visual.

To do that yourself would require some sort of fancy conditional formatting AND, I am not quite positive that you even COULD do a conditional format on a RLS affected visual.  

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!