Adding multiple AD groups to security role

[judspud]

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

[v-danhe-msft]

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-rol...

Regards,

Daniel He

[judspud]

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

[v-danhe-msft · Accepted solution]

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