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!
