Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Thank you!
to not let you test everything, as @GilbertQ mentioned, you have to give the users the Build permission, as mentioned here per the requirements of Analyze in Excel.
You can do that in the App as GilbertQ mentions, or directly on the dataset, have a look at Ways to give build permission.
Thanks, everyone! I will give these a try and report back.
Hi @crisher
You are correct that the users who are members will be able to see all the data.
What happens in the App where you put a tick for building on this dataset?
@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
Go to back to your desktop and set this up
Then republish your report.
It should work fine, I tested it.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
Proud to be a Datanaut!
Private message me for consulting or training needs.