Forum Discussion
Row Level Security issue
hi guys, i encounter a problem and i deeply need your help. i set a row level security in power bi desktop RS and it works fine i test it with "View As". then i publish the report to the report server. from the Manage>Row Level Security i add the user and assign it to the role that i created. but when i see the dashboard with that user, the role does not work. i wonder why it does not work. any comment is appreciated.
2 Replies
alisoroush7 , hope that the user is the viewer. If he is an admin, security might not apply. But even in that case, it should work in view as. make sure the role is published correctly. Republish and try
Hi alisoroush7 ,
1. What mode are you using to connect to the data source and what is your data source?
Keep in mind that RLS isn't respected if your DirectQuery connection uses integrated authentication for report readers. For Analysis Services live connections, you configure row-level security on the on-premises model.
2. Please check if these limitations are triggered?
Considerations and limitations
3. Use the latest version of Power BI RS and then republish the report.
Download Microsoft Power BI Report Server - May 2022
4. Related problems and solutions.
Solved: Power Bi Report server don´t work
Solved: how to implement RLS in SSAS
Solved: when add Domain's security group to RLS of Power B...
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
