Forum Discussion
Row Level Security
My Requirement is we needs to share the sematic models to users, Users can use this sematic models create reports and also they can bale to add third party source like excel and create reports but Row Level secuirty needs to work as well.
If I am giving Contributor role then user can edit security and delete Sematic Model as well.
Please advise how to achive this.
Thanks in advance.
Hi RamiDel1508,
Thank you for reaching out in Microsoft Community Forum.
Thank you Deku for the helpful response.
To achieve your requirement—allowing users to build reports with third-party sources while enforcing RLS, but preventing them from editing/deleting the semantic model
1. Allows users to build reports with the semantic model and add external sources (Excel) while enforcing RLS.
2. Viewer role prevents users from modifying or deleting the semantic model.
3. Grant Contributor access in another workspace for publishing composite model reports.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
12 Replies
Grant them build permissions
Contributor already having build access, I want to restrict Contributor to only Build and Edir Sematic Model where as Contributor can modify security and also can delete Sematic Model.
You need to set them as viewer
Viewer can edit semantic model? ,user needs to build reports by editing sematic model and also he can add third pary source like excel to sematic model and create reports
if we give viewer and build permission , user can edit the sematic model like addding third party like excel and create his own reports?
If we provide viwer to build permission he can able to build reports with adding external source link excel ?
Hi RamiDel1508,
Thank you for reaching out in Microsoft Community Forum.
Thank you Deku for the helpful response.
To achieve your requirement—allowing users to build reports with third-party sources while enforcing RLS, but preventing them from editing/deleting the semantic model
1. Allows users to build reports with the semantic model and add external sources (Excel) while enforcing RLS.
2. Viewer role prevents users from modifying or deleting the semantic model.
3. Grant Contributor access in another workspace for publishing composite model reports.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.Hi RamiDel1508,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.
Thank you,
Pavan.Hi RamiDel1508,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept as Solution" and give it a 'Kudos' so others can find it easily.
Thank you,
Pavan.Hi RamiDel1508,
I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.
Please continue using Microsoft community forum.
Thank you,
Pavan.
