Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
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.
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
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
3 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
8 | |
5 | |
4 | |
4 | |
2 |