Forum Discussion
Issues with row level security dataset
If you have implemented row-level security in your Power BI report, it's possible that some of your colleagues may not be able to see the data if they don't have the necessary permissions.
One way to resolve this is to either grant your colleagues the required permissions to view the data, or remove the row-level security from your report altogether.
To remove row-level security from your Power BI report, follow these steps:
- Open the Power BI Desktop file for your report.
- Select the "Modeling" tab in the ribbon.
- Select "Manage Roles" in the "Roles" group.
- In the "Manage Roles" dialog box, select the role that you want to delete.
- Click the "Delete" button.
Once you have deleted the role, save the report and republish it to the Power BI service. Your colleagues should now be able to view the report without any issues related to row-level security.
Alternatively, if you want to keep the row-level security in your report, you can add your colleagues to the necessary roles to ensure that they have access to the data. To do this, you would need to add their email addresses to the appropriate role in the "Manage Roles" dialog box.