cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Individual User Views Possible?

I have created a dashboard that displays our Incident and Service Request data.  We currently do not have a good way for our end users to see the status of their tickets or to view their open/closed tickets.  Is there capability within Power BI Online to set up a user to only be able to view tickets in their name?  A filter won't do it because we would not want an individual seeing everyone's tickets - only their own.  Is there a way to set up a default by user name when they log in or some other way?  

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Individual User Views Possible?

Hi there

Yes there is and it is called Row Level Security.

Here are more details on what Row Level Security (RLS) is:

https://docs.microsoft.com/en-us/power-bi/desktop-rls

And here is a great blog post by Kasper De Jonge who explains how to get it working:

https://www.kasperonbi.com/power-bi-desktop-dynamic-security-cheat-sheet/




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

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: Individual User Views Possible?

Hi there

Yes there is and it is called Row Level Security.

Here are more details on what Row Level Security (RLS) is:

https://docs.microsoft.com/en-us/power-bi/desktop-rls

And here is a great blog post by Kasper De Jonge who explains how to get it working:

https://www.kasperonbi.com/power-bi-desktop-dynamic-security-cheat-sheet/




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

Proud to be a Super User!







Power BI Blog

View solution in original post

Highlighted
Regular Visitor

Re: Individual User Views Possible?

Thank you @GilbertQ !!

Highlighted
Super User IV
Super User IV

Re: Individual User Views Possible?

Happy to help!




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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors