Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I've created a PowerBI report and set up roles within the report. I've published that report to a workspace and then changed the security settings on the dataset so that the roles are set up correctly.
My first question is whether I need to change any settings on the report before I share the report link or will the RLS just work now?
Second question , I've read that settings need to be updated on the workspace as well for this to work - is this true and how does this work?
Do I need to give all users viewer access to the workspace as well as having them added to the RLS?
I've had a look at the microsoft documentation but I'm still confused so I appreciate anyone who can help here.
Thanks.
Solved! Go to Solution.
Hi @PowerBINoob12 ,
For more details, please refer to:
Roles in workspaces in Power BI - Power BI | Microsoft Learn
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have a model wich I've implemented RLS, when I enter to it with the admin account that is able to view everything it is working fine, but when I enter with another account one visual fails and that not make sense because the dashboard is just loading less data than admin account. Someone know why this could happen?
You have to add users to the role in the dataset in the web app. They need to have the report shared with them; you could give them workspace read access but that's usually not recommended.
You can test viewing the report as a specific user in the dataset ellipsis menu to make sure it's working.
Hi @PowerBINoob12 ,
For more details, please refer to:
Roles in workspaces in Power BI - Power BI | Microsoft Learn
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.