Forum Discussion
Dynamic row level security and local Report Server
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!
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
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.
3 Replies
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
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.
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.
