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 All,
Im a beginner on power bi desktop, and i just create a report and set up RLS under "Manage Roles"
I view the report as the role which i assigned, and the data is correct.
Then i publish the report to a specified workspace, and view the report by using the user under these roles, the data is correct.
but the user cannot edit the report to add more viuals. so that i edit the workspace's privacy to "Members can edit Power BI content".
After the privacy changed, the user can edit the report but they see all data and able to access the dataset.
May i know how can i allow user to edit the report base on RLS and don't allow them to access/download the dataset ?
Thanks in advance.
Best regards,
Joey
Solved! Go to Solution.
If this facility of RLS and Edit permission is required for only one person, then in such case, I would suggest that instead of creating RLS, filter the data that the user is allowed to see in Power BI Desktop and publish the report, then share him/her the report with edit permissions.
But this is not good if you have multiple users requiring a similar thing.
That's the most likely way out...
Well that is not possible.
When ever you make a user as an Admin for a workspace, then RLS won't work for that user.
Similarly if you give edit permission to a Workspace, then the RLS won't work for the reports in that workspace
RLS will only work for the Read Only Members of a Workspace
See the below link for reference
If this facility of RLS and Edit permission is required for only one person, then in such case, I would suggest that instead of creating RLS, filter the data that the user is allowed to see in Power BI Desktop and publish the report, then share him/her the report with edit permissions.
But this is not good if you have multiple users requiring a similar thing.
That's the most likely way out...
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |