Dynamic row level security and local Report Server

[Learner22]

Dear Community,

I have created a dynamic role using Row Level Security. In Power BI Desktop, this dynamic role works perfectly. The purpose of this role is to ensure that employees can only see the data relevant to their own organizational unit. However, when I publish this report on the local report server and grant user permissions, they are unable to see any data.

Do you have any explanation for what the problem might be? Additionally, if you have any suggestions or solutions to resolve this issue, I would greatly appreciate your help.

Thank you in advance for your assistance!

[d_gosbell · Accepted solution]

Have you added your users to the role on Report Server as per the docs here Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Learn

[d_gosbell · Accepted solution]

Have you added your users to the role on Report Server as per the docs here Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Learn

[Learner22]

Thank you for your response. I have assigned the roles to the users on the local report server as described in the documentation. It works with other roles, but not with the dynamic role.

[Anonymous · Accepted solution]

Hi, @Learner22 

You might want to use DAX expressions. You may want to check out detailed guides and community discussions on dynamic RLS, such as those written by Reza Rad.

Solved: Dynamic row Level Security not working - Microsoft Fabric Community

Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD

Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.