Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
dpombal
Post Patron
Post Patron

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 1
v-janeyg-msft
Community Support
Community Support

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.