Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
VitoPiepoli
New Member

RLS not working anymore

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.

1 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

View solution in original post

4 REPLIES 4
josefrmorales
New Member

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
New Member

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
Super User
Super User

@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?


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.