Forum Discussion
CI/CD: Automating semantic model security (RLS/OLS role members)
- 7 months ago
Hi FrederikAage,
currently there is no out of the box and automated solution for that in Fabric.
Check out the following post not too long ago which might help you out with a third party tool:
Solved: How to migrate RLS roles assignment between datase... - Microsoft Fabric Community
Best regards!
PS: If you find this post helpful consider leaving kudos or mark it as solution
- Anonymous7 months ago
Hi FrederikAage ,
Thanks for reaching out to the Microsoft Fabric Community forum.Another approach other than the valuable one suggested by Mauro89 for assigning Row-Level Security (RLS) membership in Power BI is to use Microsoft Entra security groups. RLS roles are defined in Power BI Desktop and published to the Power BI Service, after which Entra ID security groups are assigned to those roles as a one time configuration.
Source: Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Please follow this article on how to automate creating security groups:
Configure group settings using PowerShell - Microsoft Entra ID | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Thank you
Hi FrederikAage
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.
Thank you.