Forum Discussion

dalewith's avatar
dalewith
Frequent Visitor
3 years ago

Row Level Security for on prem

I have row level security working in Power BI Desktop

 

When I deploy to server, I am able to set up row level security there

but

When I view the report (as myself) it still shows me everything

 

I am the admin for Power Bi Report Server

Is this why the RLS does not take effect?

I see for Power BI Service, admin or edit rights will have this effect, but not able to find anything for on prem.

 

Power Bi Report Server and Row Level Security

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi dalewith ,

     

    You are correct.

     If you're using the default permissions in Power BI Report Server, any user with Publisher or Content Manager permissions for the Power BI report can assign members to roles for that report.

    Also, please remeber RLS isn't respected if your DirectQuery connection uses integrated authentication for report readers.

     

    For more you may refer to Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Learn

     

    Best Regards,
    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • dalewith's avatar
    dalewith
    Frequent Visitor
    3 years ago

    no direct query for this one.

     

    so it is my admin permissions on the server?