Forum Discussion
Build permission not working
Hi, Anonymous
From my point of view, I still believe that the end-user can not both have build permission to this dataset and RLS worked on him. These two cases tell the similar thing about my opinion:
https://community.powerbi.com/t5/Service/Can-t-Get-RLS-to-Work/m-p/46964
But it’s very weird that the end-user can’t find the dataset when the report and build permission are shared to him. Because I can find the dataset and the report when I tested the sharing with build permission using the end-user account:
If you still want to make the end-user have both build permission to this dataset and RLS worked on him. I suggest you to go to open a support ticket and ask the technical support team for possiblity of solution of this problem.
https://powerbi.microsoft.com/en-us/support/
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
According to your description, you said the users are able to display reports with correct permission according to RLS. One thing you should keep in mind: The RLS can only work for the users that have only view permission to the dataset. Therefore, I don’t think that the users have been given the build permission of the dataset.
What’s more, the viewer in the new workspace is not able to edit any content in the workspace. In my opinion, you have to choose one thing between RLS and build permission for the users. Once the RLS works on them, they won’t have the build permission. Once the build permission is given, they won’t be restricted with RLS.
I suggest you to promote the users to the “Member” of the workspace so that they can find the dataset and create reports in Power BI Service.
Roles in Power BI new workspace
More info about RLS in Power BI
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Robert.
According to the document that you linked Roles in Power BI new workspace Build permission should give the user the right to create content over a shared dataset. If only Member or Contributor should have this possibility, why this option is grantable also to Viewers? Please see the quote below:
To copy a report, and to create a report in another workspace based on a dataset in this workspace, you need Build permission for the dataset. For datasets in this workspace, the people with Admin, Member, and Contributor roles automatically have Build permission through their workspace role.
Also, from what you said I understand that giving Build permission should revoke RLS for that user and give them possibility to build content - and suprisingly, for me it is working in the oppisite way. RLS is still in place, but there is still no way to access the dataset in order to create new report. In order check that, I disabled RLS and users (Viewers with Build permission) are still not able to create a report using the dataset. Maybe this is just an inconsistency between the documentation and how actually the Service works?
Hi, Anonymous
I don’t think users’ access to the dataset is related to the existence of RLS. It’s only about permission given.
What’s more, RLS can always work on the viewers of the workspace in my opinion.
Would you like to try to change the users’ role to Member or contributor in the workspace and check if they can build reports using this dataset?
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI v-robertq-msft,
Thanks for your response. I agree that RLS is not the case - that was my point, despite the RLS on/off Viewers with build can not create reports.
I have checked other access levels and this is how it looks:
- Member - can create a report / RLS does not apply
- Contributor - can create a report / RLS does not apply
- Viewer with Build - can not create a report / RLS applies
Hi, Anonymous
The test result is the same as I expected.😁 Thank you for your understanding and detailed experiment for each role in the workspace, which can also help other community members a lot. Would you like to accept your own reply as a solution so that other community members can learn from this too?
Thank you very much!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.