cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chotu27
Post Patron
Post Patron

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 "Your Information is not available"

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

Hi @chotu27 ,

 

I have a solution for you,see below:

First manage roles as below:

Screenshot 2020-11-24 143444.png

Then create a measure as below:

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

And you will see:

Screenshot 2020-11-24 143714.png

 

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

 

Best Regards,
Kelly

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

View solution in original post

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi @chotu27 ,

 

I have a solution for you,see below:

First manage roles as below:

Screenshot 2020-11-24 143444.png

Then create a measure as below:

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

And you will see:

Screenshot 2020-11-24 143714.png

 

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

 

Best Regards,
Kelly

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

View solution in original post

collinq
Super User
Super User

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!

 




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

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors