I was unable to use Row Level Security (RLS).

[Syndicate_Admin]

I allow myself to write to you because I have not been able to use Row Level Security (RLS).

We implement roles to a report, in Power Bi Desktop we can visualize it correctly and execute it as another user

But in the Power BI Service,It was configured by Group and individually the security at the Row Level but when testing with the real user of Rodrigo Alonso does not filter the configured rows,

In fact, I can't do the role test directly in the power BI service, because I can't select both elements, the person "Rodrigo Alonso Vazquez" or the "Initial Associates" role.

To test the role, it only lets me select one thing, this image corresponds when it lets me write the email, but it does not let me select the "Initial Associate" Role and the information is not filtered, in fact it still shows my email

If the user enters, he does not take the security settings, he shows his initials and his user, but he does not take the "InitialAssociation" role, that is, the role he creates is called that, but the information is not filtered.

I base myself on this URL to do it https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#using-the-username-or-userprincipa...

In the "InitialAssociation" role in the "vW_CRZ_Facturado" table, it filters the "person" field, which are the initials saved in a "varInicial" variable that the latter is filled by the "lookupvalue" function using the "userprincipalname()" function.

That same code was validated in the units of measurement and are displayed on the "Initials" and "User" cards.

I appreciate that you took the time to read the present, I remain attentive to your comments,

[jdbuchanan71 · Accepted solution]

@Syndicate_Admin 

Is Rodrigo Alonso Vazquez a member of the Power BI workspace where the report is published?  If so, RLS is not applied to them because they can get to the back-end data.

[jdbuchanan71]

From what I am reading, it doesn't matter if they are read-only member.

Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#:~:text=Row%2Dlevel%20security%20(....

Can you create another workspace and publish the report there then just share it with the user to test it?

[Syndicate_Admin · Accepted solution]

Thank you...
pass it as a viewer and so if it works

[jdbuchanan71 · Accepted solution]

@Syndicate_Admin 

Is Rodrigo Alonso Vazquez a member of the Power BI workspace where the report is published?  If so, RLS is not applied to them because they can get to the back-end data.