Forum Discussion

mpgoggin's avatar
mpgoggin
Advocate II
3 years ago
Solved

RLS for datasets from multiple workspaces

Hello! I have been struggling with the following issue around RLS. I am trying to set things up as follows. - DATASET A with RLS in Workspace A  - DATASET B with RLS in Workspace B - REPORT in Wo...
Data Protection
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi mpgoggin ,

    Row-level security (RLS) with Power BI can be used to restrict data access for given users.In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access. If you publish your Power BI Desktop report to a workspace in the Power BI service, the RLS roles are applied to members who are assigned to the Viewer role in the workspace.

     

    If you want to cancel the RLS in dataset A, you need to calcel the rls in dateset A from DATASETS A & B. Then there would only rls in dateset B .

     

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

     

    If it still does not help, please provide more details.

     

    Best Regards
    Community Support Team _ Polly

    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 mpgoggin ,

Row-level security (RLS) with Power BI can be used to restrict data access for given users.In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access. If you publish your Power BI Desktop report to a workspace in the Power BI service, the RLS roles are applied to members who are assigned to the Viewer role in the workspace.

 

If you want to cancel the RLS in dataset A, you need to calcel the rls in dateset A from DATASETS A & B. Then there would only rls in dateset B .

 

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

 

If it still does not help, please provide more details.

 

Best Regards
Community Support Team _ Polly

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

mpgoggin's avatar
mpgoggin
Advocate II
3 years ago

Thank you for the background,

To confirm then, a successful RLS scenario would mean that the User has been granted Security to the Dataset AND Viewer access to the workspace that contains the dataset.

I was hoping there was a way to apply RLS without granting access to the workspace. In other words, just share the report. My understand now is that this scenario is infeasible.

Thanks again,

Mike