topic Re: Adding multiple AD groups to security role in Service

Adding multiple AD groups to security role

judspud — Mon, 20 May 2019 13:54:15 GMT

Hi All,

Currently using AD for dynamic security.

The security works as should and I now need to add the AD groups into the security role in PowerBI Service.

Is there a quick way to add multiple AD groups at once?

Currently I am entering them one by one and clicking add which is very time consuming as I have 100's of AD groups that need adding.

Any help will be much appreciated

Thanks,

George

Re: Adding multiple AD groups to security role

v-danhe-msft — Tue, 21 May 2019 02:21:20 GMT

Hi judspud ,

Based on my research, you could use powershell to automatically add members to the AD group. This could help you just need to create one lagrge group to add to the Power BI security role.

https://community.powerbi.com/t5/Community-Blog/Power-BI-Group-management-using-Active-Directory-roles-and/ba-p/308092

Regards,

Daniel He

Re: Adding multiple AD groups to security role

judspud — Tue, 21 May 2019 07:42:51 GMT

The problem is not everyone can be part of the same AD group as they are being used by the security role.

Different AD groups can see different parts of the data.

So i need a way of adding all these AD groups to the security role in PBI

Thanks,

George

Re: Adding multiple AD groups to security role

v-danhe-msft — Tue, 28 May 2019 06:46:42 GMT

Hi judspud ,
I am afraid that you could not achieve this feature currently, I suggest you submit an idea in ideas forum:

Power BI Ideas: Hot (13793 ideas) – Microsoft Power BI

Regards,

Daniel He