Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have created a school report and when sharing it my colleagues arent able to open due to the dataset row level security. I dont intend to set roles or permissions as I want all colleagues to have access to the same report. Dont know why this is happening.
Want to be able to share so they can view.
I can see that there is a row level security created...how do I delete it? I assume I could add all colleagues to this "science/ben nevis" but I wanted a clean share...
any suggestions?
@help @service
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:
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.