RLS not working anymore

[VitoPiepoli]

Hi all,

I am in big problem.

RSL stopped working on Wednesday without any apparent reason.

It works within the app when access it via "view as" but can't get it working on the PBI RS.

All the settings are in order and the employee file has its PATH well formed.

ExtendedLog3 does not has give me any issue.

Any idea?

Thank you in advance for your help.

[josefrmorales]

Having the same issue. The report and rules did not change but Row Level Security is now not working. When I try to test by impersonating a user it works for some but not all. This seems like an issue with the service. It had been working fine for over a year.

[VitoPiepoli]

Hi @Greg_Deckler ,

everything was working fine till Tuesday afternoon.

No change was made either to the PBI model nor to the rules on the Server side.

I have been using username() since 2019 without issues.

Version June2022.

The SQL server on which RS is mounted is not managed by me though.

I don't know if they fiddled with the way the RS pick the credential or group roles.

I tried to delete the role on the server and reassign it but did not work.

[Greg_Deckler]

@VitoPiepoli I would review the considerations and limitations here: Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Learn

Are you using USERNAME or USERPRINCIPALNAME in your RLS or is the RLS not dynamic like that? Did you manage the roles and add people to them on RS?

[VitoPiepoli · Accepted solution]

Using username() (I wrote it in message 3/4) and I manage the roles and all the lot.

I fixed the issue now as the IT Department  rolled out a change in UPN without telling it to us. So I had to change the field content the username() function was poinitng to. 

Thanks