Hi, thank you, a really big thank you! I had been wondering how to implement this idea of user context reporting for months but it is not easy to find on web pages and I never dared watch youtube at work. So this is a big relief. Jojo
Angelica, this is amazing content. I've been looking for an option how to ensure my report is dynamically filtering the data based on the persona of the logged on user to ensure data that is sensitive in the visualization is in line with the Company's data protection regulatory rules... Now, I have to say that I've tried to walk the path with DAX Measures in the visuals and even the AI got confused at what I was after, but look - your content shared here hits the nail on the head and it takes 2 minutes flat to do. Thank you!
Ahh ok, i have watched a few Videos but this one is the only one that makes it clear to check both while testing out the Filter... Thought i was too dumb...
Angelica, great video! Is there a way to use the userprincipalname function to allow employees to see only their data but also allow managers to see all of their employees' data? Thanks!
Tried this today and working like a charm. Thank you!. Can you also help with how can we keep this RLS intact when subscribing this report in PowerBI service?
Does the RLS stop in Power BI Service if you are an admin at the Workspace ? This worked for me on the Desktop when I tried to "See as role" but not in the publish service version. Thanks!
Thank you for the content - my user is getting an error "The report cannot be viewed as the underlying dataset uses RLS". Any idea on what is missing? The RLS just has the one group and shows (0) members, but I do have the Role as you instructed. When I view as user - it works perfectly.
Thanks for sharing this great video. Does the userprinciplename column need to have 1:1 relationship or would it work with many to many as well? I am trying to apply this to my scenario where users have corresponding departments and "department" column has many to many relationship with fact table because there are many employees in the same department. Appreciate your help 🙂
This is great, but what if you need to apply a filter like this to just one page or just one visual, while leaving the rest of the report unfiltered? I've been banging my head against the wall all day.
Hello, I think if go to your Manage Roles, then select your role, then in the table box, select the three dots of the table you are using, select "Add Filter", instead of choosing the email column choose your username column with the method in the Table Filter DAX Expression box. [username] = USERPRINCIPALNAME() I hope this works for you.
Hi there! From the Power BI service, you would just assign the user groups instead of the individual users. RLS supports the use of distribution groups, mail-enabled groups, and security groups. Microsoft 365 groups are not supported and cannot be used for row-level security. Thanks for watching!
@@AngelicaDomenech If you have an email distribution column that has multiple email addresses with a comma or semi colon separated, when you do View As in the Power BI Desktop and enter the 2nd or 3rd email address no results. The data only displays for the first email address listed in the row. In this situation would I need to create a group?
![Power BI Security [Course Preview]](http://i.ytimg.com/vi/qkRGJz1Nr2o/mqdefault.jpg)
![Power BI Security [Course Preview]](/img/tr.png)
This is best video i have ever seen on DRLS, Great, Thank you so much!
Hi, thank you, a really big thank you! I had been wondering how to implement this idea of user context reporting for months but it is not easy to find on web pages and I never dared watch youtube at work. So this is a big relief. Jojo
Like how you used your colleagues names - enjoy their videos too.
Thanks.. I had forgotten how to work with dynamic security.. but you made it so easy and simple.. Thanks again...
Angelica, this is amazing content. I've been looking for an option how to ensure my report is dynamically filtering the data based on the persona of the logged on user to ensure data that is sensitive in the visualization is in line with the Company's data protection regulatory rules... Now, I have to say that I've tried to walk the path with DAX Measures in the visuals and even the AI got confused at what I was after, but look - your content shared here hits the nail on the head and it takes 2 minutes flat to do. Thank you!
Angelica makes PBI a breeze,thanks a lot 🤗
Ahh ok, i have watched a few Videos but this one is the only one that makes it clear to check both while testing out the Filter... Thought i was too dumb...
Angelica, great video! Is there a way to use the userprincipalname function to allow employees to see only their data but also allow managers to see all of their employees' data? Thanks!
Tried this today and working like a charm. Thank you!.
Can you also help with how can we keep this RLS intact when subscribing this report in PowerBI service?
Does the RLS stop in Power BI Service if you are an admin at the Workspace ? This worked for me on the Desktop when I tried to "See as role" but not in the publish service version. Thanks!
Thank you for the content - my user is getting an error "The report cannot be viewed as the underlying dataset uses RLS". Any idea on what is missing? The RLS just has the one group and shows (0) members, but I do have the Role as you instructed. When I view as user - it works perfectly.
Establishing relationships and making 2 tables necessary or one table will do the work?
Thanks for sharing this great video. Does the userprinciplename column need to have 1:1 relationship or would it work with many to many as well? I am trying to apply this to my scenario where users have corresponding departments and "department" column has many to many relationship with fact table because there are many employees in the same department. Appreciate your help 🙂
It doesnt. A long as the table with emails is filtering the rest of the table (1:N) it will work
This is great, but what if you need to apply a filter like this to just one page or just one visual, while leaving the rest of the report unfiltered? I've been banging my head against the wall all day.
Thank you for the video. I'm interested to know if the role security is followed in a SharePoint Web Part?
What if i share with user of other organisation?
Hi my problem is my users don’t have email its just username and i have done username() but its not filtering out?
Hello, I think if go to your Manage Roles, then select your role, then in the table box, select the three dots of the table you are using, select "Add Filter", instead of choosing the email column choose your username column with the method in the Table Filter DAX Expression box. [username] = USERPRINCIPALNAME() I hope this works for you.
Can i use this functionality if I have user with power bi free license ?
How to do it in a group instead of setting it per individual? Thanks.
Hi there! From the Power BI service, you would just assign the user groups instead of the individual users. RLS supports the use of distribution groups, mail-enabled groups, and security groups. Microsoft 365 groups are not supported and cannot be used for row-level security. Thanks for watching!
@@AngelicaDomenech If you have an email distribution column that has multiple email addresses with a comma or semi colon separated, when you do View As in the Power BI Desktop and enter the 2nd or 3rd email address no results. The data only displays for the first email address listed in the row. In this situation would I need to create a group?
should have shown how to set it after publishing this file in service.
Where are you from