Power BI Access with RLS and Workspace Access

[vamsip]

Team,

I am new to Power BI and would like to get expert suggestions regarding one query. We have implemented RLS for our power BI reports. The role which we have created is Restricted. If user is part of this role then records will be displayed based on the email id of the login user. We have added one user to this role for example user mail id is vkp@xyz.com and this user is also given Workspace access. Now, when user open the report, RLS is not getting applied on Power BI service. We have linked this report URL in Dynamics 365 CE unders reports section. When user click on that report link then it will take user to power bi service. But, the issue is that the user is able to see all the data where as the user should be able to see data since the user is part of Restricted Role. Please let us know if we are doing anything wrong here. 

[v-henryk-mstf · Accepted solution]

Hi @vamsip ,

There are a few possible reasons why the Row-Level Security (RLS) rules you have set up in Power BI are not being applied when a user accesses the report from Dynamics 365 Customer Engagement (CE). Here are some possible solutions to this issue:

• 1 Make sure that the user who is accessing the report has been added to the Restricted role in Power BI. This can be done by going to the Users tab in the Security settings of the workspace where the report is located, and adding the user to the role.
• 2 Check that the user's email address in Dynamics 365 CE matches the email address that you have used in the RLS rule in Power BI. If the email addresses do not match, the RLS rule will not be applied.
• 3 If the user is accessing the report from Dynamics 365 CE, check that the report link in Dynamics 365 CE points to the correct report in Power BI. This can be done by going to the Reports tab in Dynamics 365 CE, and verifying that the link points to the correct report in Power BI.
• 4 If you are still having problems, try clearing the cache in your browser and then accessing the report again. This can sometimes help if there are any issues with cached data.

For more details, you can read below document:

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[djurecicK2]

Hi @vamsip ,

 What role does that user have in the workspace? If they have anything higher than Viewer role, rls is not applied since their role gives them access to the entire dataset.

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls#using-rls-with-workspaces-in...