topic Re: Dynamic row level security and local Report Server in Report Server

Dynamic row level security and local Report Server

Learner22 — Wed, 07 Aug 2024 10:29:30 GMT

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!

Re: Dynamic row level security and local Report Server

d_gosbell — Wed, 07 Aug 2024 23:36:22 GMT

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

Re: Dynamic row level security and local Report Server

Learner22 — Thu, 08 Aug 2024 06:17:19 GMT

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.

Re: Dynamic row level security and local Report Server

Anonymous — Wed, 14 Aug 2024 08:54:18 GMT

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.