Forum Discussion

RMRaptor's avatar
RMRaptor
Frequent Visitor
3 years ago
Solved

RLS in Desktop & Server

Hello All   I'm working report request for setting up RLS based on Email id columns ( Developer, Lead ) , my power bi deskop version Version: 2.118.828.0 64-bit (June 2023) and its has new interfac...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi RMRaptor ,

     

    According to your statement, I think your issue is that RLS works in test as role and doesn't work when you see this report. I think this correct, due to you are the owner of the report.

    As far as I know, the user who have the edit permission to the dataset, the RLS won't work to them and will show all data.

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

    Workspace members assigned Admin, Member, or Contributor have edit permission for the dataset and, therefore, RLS doesn’t apply to them. 

     

    Best Regards,
    Rico Zhou

     

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi RMRaptor ,

 

According to your statement, I think your issue is that RLS works in test as role and doesn't work when you see this report. I think this correct, due to you are the owner of the report.

As far as I know, the user who have the edit permission to the dataset, the RLS won't work to them and will show all data.

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

Workspace members assigned Admin, Member, or Contributor have edit permission for the dataset and, therefore, RLS doesn’t apply to them. 

 

Best Regards,
Rico Zhou

 

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