Forum Discussion

imenmaiza's avatar
imenmaiza
Helper II
5 years ago
Solved

RLS doesn't work in the Report Server

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,

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      imenmaiza
      Helper II

      Hello Anonymous,

      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, 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello,

     

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

     

    thanks in advance

    • imenmaiza's avatar
      imenmaiza
      Helper II

      Hi Rayen,

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

      • Anonymous's avatar
        Anonymous
        Not applicable

        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