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'm having a problem with one of the workspaces within Power BI with regards to security. I want to lock down the workspace so that users cannot create or edit any of the existing reports within the workspace. However, when I give the members 'members can only view PowerBI content access' the reports do not display corrrectly. The users receive the attached screen errors 'cannot display visual'. If I give member the 'members can edit Power BI content' the visuals display correctly. I am wondering if anyone else has experienced this problem and knows of a workaround.
Many thanks
Jo.
Solved! Go to Solution.
OK, that means there's something wrong with the way you've set up RLS. RLS and workspace security are 2 different things. Giving them edit rights on workspace security will nullify RLS limitations. Whatever you've done with RLS, when it is active, it is causing them to get those blank results. I suspect you have not assigned the users to their roles on the published dataset. Go to your dataset, right click and hit Security. You must add each user to their role there for RLS to function. Then you can set their workspace security to read-only and it will work.
Proud to be a Super User!
oops forgot to upload the image of the error!
Are you using row level security in this dataset?
Proud to be a Super User!
Hello
thank you for your reply. Yes I am using RLS on this dataset. However, once I give my users 'members can edit power bi content' access so that they can use the reports, RLS doesn't work.
OK, that means there's something wrong with the way you've set up RLS. RLS and workspace security are 2 different things. Giving them edit rights on workspace security will nullify RLS limitations. Whatever you've done with RLS, when it is active, it is causing them to get those blank results. I suspect you have not assigned the users to their roles on the published dataset. Go to your dataset, right click and hit Security. You must add each user to their role there for RLS to function. Then you can set their workspace security to read-only and it will work.
Proud to be a Super User!
brilliant thank you. I have tried your solution and it works. It has also solved my other issue of RLS not working any dashboards generated from the dataset.
thanks again
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 |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |