Row Level Security in Report Server with Direct Query

[dpombal]

I need to use Row Level Security in a report with  Direct Query connection to SQL Server published in Power BI Report Server.

But I don't understand this limitation, I am nos sure which type of security my server is using. Looking for ideas on how to perform RLS in  Direct Query over  Power BI Report  Server

If you're using integrated security with DirectQuery, then your users may notice:

• RLS is disabled and all data is returned.
• Users can't update their role assignments, and get an error on the RLS Manage page.
• For the DAX username function, you continue to receive the username as DOMAIN\USER.

Report authors don't have access to view the report data in Power BI Report Server until they've assigned themselves roles accordingly after uploading the report.

Role assignments through group memberships are only supported when the Power BI Report Server is configured to run with NTLM or Kerberos authentication. Servers running with Custom authentication or Windows Basic need users explicitly assigned to roles.

[v-janeyg-msft]

Hi, @dpombal 

I suggest you ask about sql server admin. If there is no special configuration, just set up RLS directly, please refer to the link below for specific tutorial. Just use DOMAIN\User format.

Choose an Authentication Mode - SQL Server | Microsoft Docs

RLS setting:

Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Docs

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey