RLS doesn't work in the Report Server

[imenmaiza]

Hello,

I am facing a problem with RLS and I deeply need support, 

In July 2020, we have built a report containing RLS, we have saved it in the Report Server, tested it with colleagues and everything worked perfectly.

Unfortunately, now it doesn't work anymore in the report server. However in the Power BI desktop when I test with view as, everything works fine. For example,  I set myself as Manger. However, when I affect myself to the Manager role in the report server, I don't see any team. (Please be advised that it's the same report and it  worked before on the report server)

Does this have anything to do with the Power BI Report Server version,? now we are using Microsoft Power BI Report Server - January 2021 version.

I look forward to your support,

Best Regards,

[Anonymous]

Hello,

I have the same problem, email and session name are fine but RLS still not working in report server

thanks in advance

[imenmaiza]

Hi Rayen,

Make sure that the Email finishes with .com in the end.

[Anonymous]

Hello imen

Yes the email is fine and it finish with .com , note that when i use the option view as in Power BI Desktop it works fine but only on report server i have the problem, that's so weird

Any other suggestions ?

thanks

[V-pazhen-msft · Accepted solution]

@imenmaiza 

The version should not be the cause, RLS worked fine in my Jan version. Did you change any data in the datasource? Please try re-save the new pbix to Report Sever and test again.

Here are the limitations:
Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[imenmaiza]

Hello @V-pazhen-msft,

I rechecked and it was a mistake in the Emails.

Thank you for your support, I wanted to make sure if it was related to Power BI version.

Best Regards,