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.
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?
Community SupportHi, 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
- v-robertq-msft
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.
Hello,
I still do not see any solution. From what I understand from Build permission for shared datasets document, Viewer with Build permission should be able to create reports - my post only proves that in my case it is not working that way. Either the documentation is misleading, or I am not getting it right. Could you please advise?