Row Level Security issue

[alisoroush7]

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.

[Anonymous]

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.

Solutions in the past

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 Team

If 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

[amitchandak]

@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