Security Role Management.

[pq0310]

POWER BI를 TEAMS에 게시 후 편집을 통해 보안 역할 관리를 제거했습니다.

그런데 POWER BI를 게시할 때마다 역할 관리에 들어가서 제거를 눌러야 합니다.

혹시 게시할 때마다 역할관리가 자동으로 제거되는 방법이 있나요?

[v-hashadapu · Accepted solution]

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

[rohit1991]

Hi @pq0310 ,

Power BI를 Teams에 게시한 후 매번 역할 관리에서 보안 역할을 수동으로 제거해야 하는 불편함이 있으시군요. 현재 Power BI에서는 보고서를 다시 게시할 때마다 역할(보안 역할) 설정이 덮어써지기 때문에, 자동으로 역할이 제거되는 방법은 제공되지 않습니다. 즉, 매번 게시 후 직접 역할 관리를 통해 제거해야 합니다. 자동화가 필요하다면 Power BI REST API를 활용하여 배포 후 역할을 제거하는 스크립트를 개발하는 방법이 있으나, 기본적으로는 수동 관리가 필요합니다.

You’re experiencing inconvenience because you have to manually remove security roles in Role Management every time you publish Power BI to Teams. Currently, Power BI does not provide a way to automatically remove roles when publishing a report. Each time you publish, the role settings are overwritten and must be managed manually. If you need automation, you could consider developing a script using the Power BI REST API to remove roles after deployment, but by default, this is a manual process.