Forum Discussion

chotu27's avatar
chotu27
Post Patron
5 years ago
Solved

Handling Row Level Security

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 "Y...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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's avatar
collinq
Super User
5 years ago

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!