Forum Discussion
Security Role Management.
Hi pq0310 , Thank you for reaching out to the Microsoft Community Forum.
When you publish a Power BI report to the Power BI Service, even if it's embedded in Microsoft Teams, any Row-Level Security (RLS) roles defined in Power BI Desktop are retained and overwrite existing roles in the service. That’s why after every publish, you find yourself needing to manually remove roles again.
To stop this from happening, you need to delete the roles directly in Power BI Desktop before publishing. Go to Modeling -> Manage Roles, delete all roles, save the file and then publish. Once you do this, there will be no roles applied, and nothing to remove afterward.
Currently, there’s no built-in option or automation in Power BI or Teams to remove RLS roles automatically after publishing.
Please refer:
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Embed Power BI reports in Microsoft Teams - Power BI | Microsoft Learn
Community SupportHi pq0310 , Thank you for reaching out to the Microsoft Community Forum.
When you publish a Power BI report to the Power BI Service, even if it's embedded in Microsoft Teams, any Row-Level Security (RLS) roles defined in Power BI Desktop are retained and overwrite existing roles in the service. That’s why after every publish, you find yourself needing to manually remove roles again.
To stop this from happening, you need to delete the roles directly in Power BI Desktop before publishing. Go to Modeling -> Manage Roles, delete all roles, save the file and then publish. Once you do this, there will be no roles applied, and nothing to remove afterward.
Currently, there’s no built-in option or automation in Power BI or Teams to remove RLS roles automatically after publishing.
Please refer:
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Embed Power BI reports in Microsoft Teams - Power BI | Microsoft Learn