Skip to main content
Microsoft Idea

Power BI

Needs Votes

Enterprise Gateway - Active Directory Security Groups as Users

Vote (36) Share
Troy Marrick's profile image

Troy Marrick on 19 Sep 2018 00:03:49

In the gateway data source I am forced to add each user individually to allow them to create a report off that data source.
Alternately I can create custom groups in o365.
We have already established security groups on our system would it be possible for these groups to be used?
This is an extra layer of security for hundreds of users that has already been solved through active directory synchronization with office 365.

The use case is to add a security group or multiple group to be authorized to create reports off the data source. When we add or take out personnel
from the security group it will propagate up to Power BI.

Comments (4)
Troy Marrick's profile image Profile Picture

Jon Fortner on 02 Jun 2021 21:03:34

RE: Enterprise Gateway - Active Directory Security Groups as Users

Already there, see https://ideas.powerbi.com/ideas/idea/?ideaid=219e1baf-05a6-4067-b7dc-bbf28357ff00

Troy Marrick's profile image Profile Picture

Godzilla on 06 Jul 2020 00:08:08

RE: Enterprise Gateway - Active Directory Security Groups as Users

If anyone stumbles upon this, the way we got this to work was by adding an email address to the AD Security group Email field. It wasn't even a real email address in our domain. Once we did that, we were able to use our AD Security Group in the Gateway.

Troy Marrick's profile image Profile Picture

Ken Y on 05 Jul 2020 23:36:06

RE: Enterprise Gateway - Active Directory Security Groups as Users

Seriously, I cannot believe that this is still an issue? Last meaningful comment from previous "completed" idea was from November 2016 suggesting "there might have been a regression"

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13279605-enterprise-gateway-active-directory-security-gro

Might? How about - intellisense recognizes the group, but same problem - click on presented group and get error "email address invalid or duplicate"

Troy Marrick's profile image Profile Picture

Benjamin Hanna on 05 Jul 2020 23:33:10

RE: Enterprise Gateway - Active Directory Security Groups as Users

Active Directory security group
Manage access through Active Directory security groups. A distribution list is only helpful to a point. Active directory is already used for so many things, having the ability to manage the security to dashboards and reports would be very helpful.

I want to parrot this idea that was closed three years ago without implementation.