Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi
I have a on-Prem Power BI report server where I upload pbix dashboards to. I am using row level security on a number of dashboards where i have defined groups that I manually assign users to. I would like to be able to assign users dynamically using REST APIs like Add Group User (https://docs.microsoft.com/en-us/rest/api/power-bi/groups/add-group-user)
I was wondering if this is possible on a on premise report server where we upload the pbix files to?
Will it only work for Power BI premium (Service) where I define workspaces, datasets and reports?
Is there any way to achieve this using APIs or via code?
Thanks
Jim
Solved! Go to Solution.
Outsource this to AD. In your RLS roles specify AD groups, not users. Then maintain group membership in your AD management tool.
Outsource this to AD. In your RLS roles specify AD groups, not users. Then maintain group membership in your AD management tool.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |