Forum Discussion
Dynamic RLS works when testing but not in the actual published report
I created a permissions table for dynamic row level security. I tested it within the report and it works for different users to filter the data based on their permissions.
Then I published the report, added the users to RLS security in the semantic model of the report and tried to test the role for my own user and the testing worked. However, when other users open this same published report, it doesn't filter the data for them despite it working when I tested from the .pbix file using View As option.
What could be possible reasons for it not working in the report?
Thank you in advance.
Thank you audreygerred for your prompt reply.
Hi afaro ,
Based on the information you have provided, it appears that you have set up and tested RLS correctly and are only experiencing issues after publishing the report to the Power BI service.
It is important to note that RLS only works for the Viewer role in the workspace, ensure that users are correctly assigned to the appropriate role in the workspace. Please refer to the following documentation for more information:Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Thank you audreygerred for your prompt reply.
Hi afaro ,
Based on the information you have provided, it appears that you have set up and tested RLS correctly and are only experiencing issues after publishing the report to the Power BI service.
It is important to note that RLS only works for the Viewer role in the workspace, ensure that users are correctly assigned to the appropriate role in the workspace. Please refer to the following documentation for more information:Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello! For the person you are testing with, did you share a link to the report, push it to an app, or do they have access through the workspace?
