Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
Does the Power BI Report Server (Version - March 2018) support Row Level Security?
Power BI Desktop (March 2018) does provide the "Manage Roles" functionality and I was able to create RLS (Table filter DAX) in Desktop with direct query connecting to SQL Server DB but after publishing it to Report Server, I do not see an option to manage RLS.
1) how can I manage those roles/users/groups in Report Server for the above scenario?
Here is a latest Microsoft article which tells that Row Level Security supports "Only through data source in DirectQuery mode".
2) What does that mean? Does it support Direct Query data connection through SQL Server DB? Does it work after publishing it to Report Server? If Yes, how to do it and how does it work?
https://docs.microsoft.com/en-us/power-bi/report-server/compare-report-server-service
3) Is it possible to use RLS based on Active Directory groups in Report Server? How? Should the AD group be table driven?
Should I even create RLS (Table filter DAX) in Desktop with direct query connecting to SQL Server DB if I want to use the AD group?
Note:
-I tested RLS in Power BI Service and works fine.
-Our organization does not use SSAS.
I did go through number of Microsoft articles and community posts. It points to the older Power BI versions or talks mostly about Power BI Service.
Any insights on how it works only in Power BI Report Server connecting to SQL Server DB and with use of AD Group will be very helpful.
Thanks!
I'm also really interesting in this topic.
Hi there,
Did you ever get a response on these very simple but pointed questions from Microsoft?
I would really like to know what to tell my clients now regarding RLS and Power BI Report server. SSAS is not an option, and neither is using the service.
@Microsoft, please just tell us how exactly you say RLS is supported using direct query on SQL server 2016+?
Hi @BBIUser
We have implemented it via SSAS but I have seen another post recently where someone has done it by creating a table in SQL (see link below):
I hope this helps.
James
User | Count |
---|---|
4 | |
3 | |
3 | |
2 | |
2 |