Forum Discussion
Export is not filtering the row level security
Hello schaetzles!
You are right this should be due to your role as the Admin in the workspace. Any role except the Viewer role will not have RLS applied to them. From the documentation:
"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. Even if Viewers are given Build permissions to the dataset, RLS still applies. For example, if Viewers with Build permissions use Analyze in Excel, their view of the data will be protected by RLS. Workspace members assigned Admin, Member, or Contributor have edit permission for the dataset and, therefore, RLS doesn’t apply to them. If you want RLS to apply to people in a workspace, you can only assign them the Viewer role. Read more about roles in workspaces."
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Try to create a user with the viewer role and see if RLS applies.
Best,
MatthiasPaul
Hello schaetzles!
You are right this should be due to your role as the Admin in the workspace. Any role except the Viewer role will not have RLS applied to them. From the documentation:
"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. Even if Viewers are given Build permissions to the dataset, RLS still applies. For example, if Viewers with Build permissions use Analyze in Excel, their view of the data will be protected by RLS. Workspace members assigned Admin, Member, or Contributor have edit permission for the dataset and, therefore, RLS doesn’t apply to them. If you want RLS to apply to people in a workspace, you can only assign them the Viewer role. Read more about roles in workspaces."
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Try to create a user with the viewer role and see if RLS applies.
Best,
MatthiasPaul