Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
103 | |
101 | |
84 | |
77 | |
66 |
User | Count |
---|---|
135 | |
109 | |
104 | |
83 | |
73 |