We have a workspace that was recently updated. Inside this workspace, we have a Power BI dataset with RLS. The primary use cases for this dataset is two-fold:
This is what we have noticed...
I understand the permissions requirement around not allowing "Viewers" access to "Analyze in Excel". That is by design. However, what are we missing about the new workspaces that have caused us not to be able to achieve both of these results? We have confirmed that the RLS is in place correctly.
@GilbertQ I specifically tested with a user and giving them build permissions on top of the Viewer permissions did not fix the issue.
Hi @crisher ,
You might be having a couple of things at odds in the setup. If you have configured a workspace so that members have edit permissions then RLS won't be applied to that user. If you are allowing folks to get to the entire data set then you are specifically trying to NOT use RLS - because you are allowing them to get to the ENTIRE dataset.
It sounds like you might be trying to restrict some actions based on a report and not the entire workspace. You could try to put the report into a specific workspace with limited permissions and then share that with RLS.
This would allow you to share the report such that the users could use Export To Excel based on what they see, and not based on the entire dataset. You might also have to adjust the security groups that you allow to Export in the Power BI Admin Portal.