Forum Discussion

dpombal's avatar
dpombal
Post Partisan
4 years ago

Row Level Security in Report Server with Direct Query

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.

1 Reply