rls direct query
3 Topics
Power Bi Report server don´t work
Hello. I'm having problems with my RLS. I'm configuring the rules in ssas and doing the direct query for power bi desktop. So far it works fine, the problem is when I deploy it to my company's Report Server, it doesn't work; the User can see everything.Solved4.6KViews0likes11CommentsReport Server Sept 2019 Release - Row Level Secruity using Direct Query problem.
I've been following the instruction posted: https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server I've created two roles in power BI desktop and they work correctly. When I save the PowerBI report to the report server I get the error message. Row-level security is not available for reports using Direct Query with integrated authentication. Learn more According to: https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server " You can also configure RLS on reports that use DirectQuery, such as SQL Server. Keep in mind that RLS isn't respected if your DirectQuery connection uses integrated authentication for report readers. " So I changed my Direct Query Connection in the Power BI desktop to database authentication. However this did not fix the problem. I guess I don't understand what needs to be configured to get Direct Query with RLS setup. Can you provide more detail on the configuration to do RLS and Direct Query? ThanksSolved1.2KViews0likes1Comment