Forum Discussion

ferflo's avatar
ferflo
Regular Visitor
3 years ago
Solved

Row Level Security not applying to some users

Hello community, 

 

I am currently facing an issue with Power BI. 

I have created some dashboards connected Analysis Services. 
The dashboards are shared in SharePoint via the embed option. 

I am using SSMS to manage the row-level security part. 

I am facing some issues with my dashboards. 
For users without Power BI license, the row-level security is working properly and filtering the user scope.
The dashboard is filtered using a DAX formula applied to some tables in SSMS. 

When I share the dashboard to a user with a Power BI license, the filter applied is not working properly and the user can see all the data. 
I need to be sure the dashboard is properly filtered for all the users as we are sharing very sensitive data. 

If you have faced the same issue and find a solution, don't hesitate to tell me. 

Thank you in advance,
Florian

  • ibarrau, we found the answer. 
    The RLS don't apply if you are added in Properties of the Analysis Services Server. 

2 Replies

  • Hi, be sure to check the roles of the people with licence at Power Bi Service Workspace. Only Viewers or users with no build permission (individual share) will apply RLS. Otherwise they will see all data because the have edit permission and you need to see all data to edit.

    I hope that helps,

  • ferflo's avatar
    ferflo
    Regular Visitor

    ibarrau, we found the answer. 
    The RLS don't apply if you are added in Properties of the Analysis Services Server.